|
|
|
|
|
| | |
| |
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: |
Re: Searching from database |
|
From: |
Pete |
|
Date: |
2/23/1999 7:23:58 AM |
|
IP: |
193.133.140.50 |
Try sticking another % (wild card symbol) before the search varible as well as after it.
fname = Request.Form("name")
sql = "SELECT * FROM Database WHERE Name LIKE '%" & fname & "%' order by Name"
that will do it.
Pete |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
