|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Drop Down List |
|
From: |
Charles |
|
Date: |
4/2/2000 11:56:47 PM |
|
IP: |
165.121.116.84 |
I have the drop down list populated from my Access database but cannot get the sql query to work that the drop down list form posts to. I get the error message:
ADODB.Recordset error 800a0cc1
Item cannot be found in the collection corresponding to the requested name or ordinal
Here is the code from the SQL query that the form posts to:
<%
manufacturer = Request.Form("manufacturer")
strSQL = "select Manufacturer, PartNumber, ProductTagLine, EsiPrice, Msrp, qoh from webproducts where manufacturer = " & manufacturer & ""
Set objRS = objConn.Execute(strSQL)
Do while not objRS.eof
%>
Thanks in advance for your help. |
Follow Up - Re: Drop Down List - WarnerJan Veldhuis 4/6/2000 5:32:32 AM
Follow Up - Re: Drop Down List - Nic 4/14/2000 12:05:52 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
