#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    UK
    Posts
    32
    Rep Power
    12

    Passing data in URL


    Hi

    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

    James
  2. #2
  3. No Profile Picture
    Overly white
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Fresno, CA
    Posts
    83
    Rep Power
    12

    Request.QueryString


    "SELECT * from tlbbusiness where businessID = (im not sure) "
    Since you are passing the businessID in the URL you use Request.QueryString to return the value of businessID.

    Code:
    "SELECT * from tlbbusiness where businessID = " & Request.QueryString("businessID")
    This will put the value of businessID into your SQL query.

IMN logo majestic logo threadwatch logo seochat tools logo