[thelist] ASP help needed

[Marc Seyon]

Message from Marc Seyon (11/22/2002 01:46 PM)
>Message from Kathleen Heytink (11/22/2002 10:34 AM)
>
>>I pulled the script on this page -->
>>http://www.winebow.com/test5d.asp?producer=1 from one of the other pages on
>>our web site, because it does what I want - display a list of wines for a
>>given producer.
>>
>>However when I attempt to add it to this page -->
>>http://www.winebow.com/Nshortdet.asp?ID=206  I'm getting an error.
>
>Shot in the dark.
>
>Might the problem be that the original script looks for a value named
>"producer" from the querystring? The value it would find in the second page
>is named "ID".

Ok, actually took a look at the code now. Found these two lines:

sqlstr = " select varietalname from winefact where estate = " &
request.querystring("producer")

sqlstrimg = "select prodname from producer where id = " &
request.querystring("producer")

Perhaps changing those to request.querystring("ID")

regards.
-marc