2. ASPRunnerPro General questions
  3. Newbie needs help passing variable to the SQL Query
This topic is locked

Newbie needs help passing variable to the SQL Query

 		11/25/2009 2:56:22 PM
ASPRunnerPro General questions
D
 damianb author

Let me start by saying I'm new to ASP code and code in general. What I'm trying to do is to change the Index.html to have a form that takes in two integers upon submitly and passes them to the SQL query into the WHERE statement. Can anyone tell me who to achieve this, most importantly the passing of the variables?
Thanks,

Damian
J
 		Jane 11/26/2009

Damian,
you can pass variables from custom page in the URL.

Then check URL in the List page: Before SQL query event and edit SQL query if needed:

http://www.xlinesoft.com/asprunnerpro/docs/dynamic_sql_query.htm
D
 		damianb author 11/29/2009



Damian,
you can pass variables from custom page in the URL.

Then check URL in the List page: Before SQL query event and edit SQL query if needed:

http://www.xlinesoft.com/asprunnerpro/docs/dynamic_sql_query.htm


I wish I could say this made sense, but it doesn't. Again, I have almost no knowledge of ASP.