|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Help with asp form... |
|
From: |
Shelley |
|
Date: |
4/25/2001 1:01:22 PM |
|
IP: |
209.31.21.217 |
Hi I just joined the group and need a little help. I am trying to query data where the user puts in their zipcode into an asp form and the first three numbers i.e. 985 or 984 bring up all the dealers in my database located in zipcodes that start with the same first three numbers. I am using SQL statements right now but if someone knows of another way then that's great too!
Dim strZipCodes
strZipCodes = Request("Zipcodes")
Dim strSQL
strSQL = "SELECT * FROM actable1 WHERE Zipcode LIKE " & Left(strZipCodes, 3)
RIght now it's returning nothing.
I tried using TRIM before Request("Zipcodes") also but it only returned zipcodes that match exactly. If anyone can help me it would be greatly appreciated. I have to finish this form by tomorrow. AHHH!!
Thanks so much,
Shelley |
Follow Up - ...like 945% - maria 4/29/2001 1:37:54 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
