Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Search in a SQL Database???		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pazarac
Starting Member

1 Posts
Posted - 19 March 2001 :  04:31:38  Show Profile  Send pazarac an ICQ Message
HI,
i need a Script for Seach in a Sql Database??? There are 5 textfields and the Script musst search for all Fields.

Can you tell me where i can find the Script or an Tutorial???

BYE

PAZARAC

P.S Sorry for my bad English;-(

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts
Posted - 19 March 2001 :  06:42:56  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
You just want to do a:

SELECT field1, field2, field3, field4 
  from tablename 
 where field1 like '%'&searchvalue & '&'
    or field2 like '%'&searchvalue & '&'
    or field3 like '%'&searchvalue & '&'
    or field4 like '%'&searchvalue & '&'


You might also want to consider using the LOWER function before doing the compares to make sure to ignore cases.

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07