|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Passing info from html form fld as variable into sql in ASP |
|
From: |
Chris Williams |
|
Date: |
2/19/1999 4:47:33 PM |
|
IP: |
207.51.163.13 |
If zipcode is a text field do something like this.
<%
myzipcode = request.form("zipcode")
SQLQuery = "SELECT * FROM tblOutlets WHERE (zipcode = ' " & myzipcode & " ')"
%>
If zipcode is a number field do something like this. Note the lack of single quotes
<%
myzipcode = CInt(request.form("zipcode"))
SQLQuery = "SELECT * FROM tblOutlets WHERE (zipcode = " & myzipcode & ")"
%> |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
