Hi
Im using MYSQL and ASP
Im trying to implement a Search cross ALL 40 Fields in the table I have
tried lines like
b_search = b_search & "[AGENOTES] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[MARITALSTATUS] LIKE '%" & pSearch & "%'
OR "
b_search = b_search & "[CHILDREN] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[PARENTS] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[SIBLINGS] LIKE '%" & pSearch & "%' OR "
b_search = b_search & "[YEARSMARRIED] LIKE '%" & pSearch & "%'
OR "
b_search = b_search & "[JCPUBLICATIONDATE] LIKE '%" & pSearch &
"%' OR "
b_search = b_search & "[POSITION] LIKE '%" & pSearch & "%' OR "
to build the search but I get a Query is to Complex error returned.
Am I going the right way about this ?
I think I can possibly index the fields and then maybe query the index ?
Any pointers would be appreciated
Regards
John Berman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
