Forums
This topic is locked
Multiple Culum Keyword Search - Help
Posted 02 Mar 2005 18:19:48
1
has voted
02 Mar 2005 18:19:48 Mashkur Alam posted:
Hi Everybody,Just quick question -
I have created a Keywords Text Box in the page - with the 'Title' Culum.
Its working fine.
Need to know, what is the SQL Quary for multiple culum Search???
Currently - I used:
WHERE Title LIKE '%MMCOLParam%'
Name: MMCOLParam
Value: %
Run-time Value: Request.QueryString("Key"

Look forward from you.
Regards
Babu
Replies
Replied 02 Mar 2005 21:00:01
02 Mar 2005 21:00:01 Mashkur Alam replied:
Hi
Found the solution...bit easy...way
WHERE Title LIKE '%MMCOLParam%' OR Region LIKE '%MMCOLParam%' OR PostCode LIKE '%MMCOLParam%' OR Type LIKE '%MMCOLParam%'
Cool everything works fine....
Thanks to
Andres Cayon.
Spain Dreamweaver MMUG Manager
www.esmmug.com
Regards
Babu
Found the solution...bit easy...way
WHERE Title LIKE '%MMCOLParam%' OR Region LIKE '%MMCOLParam%' OR PostCode LIKE '%MMCOLParam%' OR Type LIKE '%MMCOLParam%'
Cool everything works fine....
Thanks to
Andres Cayon.
Spain Dreamweaver MMUG Manager
www.esmmug.com
Regards
Babu