|
|
|
|
|
| | |
| |
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: 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
