April 3rd, 2003, 11:56 AM
Passing data in URL
I am passing a variable called businessID from one page to the next page in my URL. On the next page I want to use the value of businessID to query my access database in a SELECT statement. How do I put this in my SELECT statement?
"SELECT * from tlbbusiness where businessID = (im not sure) "
Thanks for any help
April 3rd, 2003, 01:03 PM
Since you are passing the businessID in the URL you use Request.QueryString to return the value of businessID.
This will put the value of businessID into your SQL query.
"SELECT * from tlbbusiness where businessID = " & Request.QueryString("businessID")