Passing data in URL

Dev Shed Forums Sponsor:

April 3rd, 2003, 10:56 AM

Jay69

Contributing User

Join Date: Mar 2003

Location: UK

Posts: 32

Time spent in forums: < 1 sec
Reputation Power: 11

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

April 3rd, 2003, 12:03 PM

defjamninja

Overly white

Join Date: Mar 2003

Location: Fresno, CA

Posts: 83

Time spent in forums: < 1 sec
Reputation Power: 11

Request.QueryString

Quote:

"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.

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Passing data in URL

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump