|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Passing info from html form fld as variable into sql in ASP |
|
From: |
Jerry |
|
Date: |
2/19/1999 12:16:42 PM |
|
IP: |
198.238.238.87 |
I have have html form that collects a simple string. When the submit button is pressed, I want to pass what was entered into a WHERE clause to filter the result set. I am having problems getting the correct syntax for this...
<%
...
SQLQuery = "SELECT * FROM tblOutlets WHERE zipcode =<%= request.form("zipcode")%>"
...
%>
The problem line of script is this:
SQLQuery = "SELECT * FROM tblOutlets WHERE zipcode =<%= request.form("zipcode")%>"
Without the WHERE clause it all work fine.
Any ideas on the syntax to do this?
Thanks all!
Jerry |
Follow Up - Re: Passing info from html form fld as variable into sql in ASP - Harlan 2/19/1999 2:40:03 PM
Follow Up - Re: Passing info from html form fld as variable into sql in ASP - Chris Williams 2/19/1999 4:47:33 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
