| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
passing values from a listbox to a select statement |
|
From: |
Carl |
|
Date: |
1/7/2001 4:00:11 PM |
|
IP: |
38.221.252.55 |
I am getting the following error when I try to pass a listbox value to an asp page that takes that value and uses it in a select statement.
Here it is:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
location = Request.form("state_name")
cmdStr ="SELECT ID_NO, First Name, Last Name, Company, City, State FROM npl WHERE State = Request.form("state_name")"
********************************************
I get the same message when I try the select statement this way.
location = Request.form("state_name")
cmdStr ="SELECT ID_NO, First Name, Last Name, Company, City, State FROM npl WHERE State = ("&location&")"
|
Follow Up - Re: passing values from a listbox to a select statement - TTT 1/7/2001 5:22:55 PM
|
|
|
|
|
|
