|
|
|
|
|
| | |
| |
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: |
Searching from database |
|
From: |
Timo Tuunainen |
|
Date: |
2/23/1999 5:44:34 AM |
|
IP: |
195.148.253.200 |
I'm now using the following SQL statement, but it one major drawback; if I search for
example with "a", it only finds the data which begins with "a" not words like "car".
Does someone know how it could be done? Please help me!
...
fname = Request.Form("name")
sql = "SELECT * FROM Database WHERE Name LIKE '" & fname & "%' order by Name"
... |
Follow Up - Re: Searching from database - Pete 2/23/1999 7:23:58 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
