|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: passing values from a listbox to a select statement |
|
From: |
TTT |
|
Date: |
1/7/2001 5:22:55 PM |
|
IP: |
172.143.179.62 |
You need to enclose the string value with single quotation marks:
location = Request.form("state_name")
cmdStr ="SELECT ID_NO, First Name, Last Name, Company, City, State FROM npl WHERE State = '" & location & "'" |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
