Links to call db

Results 1 to 2 of 2

Thread: Links to call db

  1. #1
    Join Date
    Dec 1969

    Default Links to call db

    What i have is a left frame with a bunch of options but based on the link they put they will pull different data.<BR><BR>Ex: if i have a link called hats i want to pull up all the info about hats. if I have a link called golf shirts i want to pull up all the info on golf shirts<BR><BR>I know there is something like you can use like store.asp?itemcat=hats<BR><BR>but i dont know how to get it into an sql statement if that is even possible. <BR><BR>any help would be aprecated,<BR><BR>MAtt

  2. #2
    jimmy Wang Guest

    Default RE: Links to call db

    Sure!<BR>let&#039s say you&#039ve a page called showme.asp, and all your itemcat link points to this "showme.asp".<BR>in showme.asp, put the following code in<BR>&#060;%<BR>dim itemcat<BR>dim sql<BR>itemcat=request.querystring("itemcat")<BR>< BR>sql="select * from thisTable where itemcat=&#039"&itemcat&"&#039;"<BR>&#039&#039 now you&#039ve got dynamicaly built sql statement <BR>%&#062;<BR><BR>Hope it solves your problem.<BR>Jimmy Wang<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts