Don't feel bad about asking questions! Some people may be experts at one thing and have no clue on another. We are all here for self improvement and fun.
LOL, now I feel bad for not asking 3 days ago! I swear I tried that and it didn't work (got an error about the last AND statement, but I tried it again today as you suggested and guess what - IT WORKED!!!!
I'm now only getting one wrong answer in the government/courts category and I suspect that this is because it has somehow been assigned a wrong category. I'll check that.
Anyway, thanks to the three of you that came up with the solution.
This part I'm going to have to study to understand:
>>Also, if your where clause includes a human entered field that might be left blank, you may want to add 'where 1=1' into your select, and then have the optional search fields 'and searchwhatever' and 'and second search'. By starting the where clause as 1=1, each field that might be optional (i.e. you use a <cfif the form was entered, then do an 'and whatever'> can all be written with 'and' clauses instead have having to guess which one might be first and not having the 'and' added in twice.>>>
Peggie
Brown Holdings LLC Group
Giving Vision to Your Business
Http://www.BusinessSights.com
=========================================================
Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com
To send email to the list, email [EMAIL PROTECTED]
To unsubscribe, send an email to [EMAIL PROTECTED]
with the following in the BODY of the message:
unsubscribe kcfusion
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
