|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: forms and DBs |
|
From: |
Harlan |
|
Date: |
2/11/1999 8:41:25 AM |
|
IP: |
206.222.20.2 |
well, I`m going to assume you already can connect to your database, and know enough sql to write a select statement. If you arent that far, you might want to do a little reading. Anyway here is how you can select records that aren`t = but are `like`.
Select [cmnField1,cmnField2,..cmnFieldN] from [tblTableName] where [fieldX] like `%[SearchItem]%`
A few notes on Like searches
`%abc%` would return anything with "abc" in it
`%abc` would return anything ending in abc
`abc%` would return anything starting with abc
%123% (notice the lack of single quotes) will find any number with 123 in it.
You don`t need single quotes for integers, and some databases will get made if you put them.
I also substituted ` for single quotes because I believe this forum removes them, and its important you have them in your select. |
Previous Message
Follow Up - Re: forms and DBs - Paul Aquino 2/11/1999 9:15:03 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
