SQL=' "SELECT * FROM bags WHERE ITEM=("url")"

hello:
please help...
i am trying to find the value that i need to insert after the "=" sign so that it can bring up the item summary page request without adding the ITEM number manually. i hope it makes sense in what i am asking.

this is the SQL statement, but i know that it is incorrect:
'SQL= "SELECT * FROM bags WHERE ITEM=("url")" if i use
'SQL= "SELECT * FROM bags WHERE ITEM=62" than it works, but i need to replace the item number ( 62) to string that will grab the pathing request


can you please help me to modify the end of it after the "=" sign?

hope this example will help to understand me better:
when the cutomer is on "allproducts.asp" page and is clicking on one of the items thumbnail, it will redirect him to "itemsummary.asp" page that will bring up the info about that item.

tons of thanks!!
-serg

If you are sending the item number on the "allproducts.asp" page in the thumbnail link (i.e. Something like <a href="itemsummary.asp?item=62"><img src="thumbnail62.img"></a>), then in "itemsummary.asp" you need to retrieve this value from the query string to put into your SELECT statement. The query string is accessible through the Request.QueryString object (i.e. Request.QueryString("item")).

Request.QueryString("item") should then give you your value of 62 to put into you SQL statement.



Hope this helps.

I can;t thank you enough!!!!!!!!!!

It works!!!!!!!!!!!!!!!!

Tons and tons of thanks!!!!!!!!!!!!

-serg