I am running a stored query from the asp page, if I use a string it works 100% I just want to know how to use a veriable instaed of a string. My veriable is assigned from a form and works, if I Response.Write it gives me the data entered in the form. I am very new to ASP and I know this is a simple thing but I cannot get it to work.

' executing stored procedure
Set mos = con.Execute ("exec sqfind '64-12345-00'") --works


' executing stored procedure
Set mos = con.Execute ("exec sqfind 'veriable'") ---- where varaible in my variable?

Thanks for the great articles, they have helped me quite a lot.

Try this:

' Set your variable here
myVariable = "64-12345-00"

' Build Stored Proc String
strStoredProc = "exec sqfind '" & myVariable & "'"

' Call the Stored Proc
con.Execute strStoredProc

That should do it! Regards,

Giovanni