been searching and can't find this-
I've got a data table with half a dozen columns:
Category,SubCategory,ProductName,ShortDescription,LongDescription
I need to create a query based on a search form that will allow the visitor
to put in multiple words, and check an "AND" or "OR" option for a more
advanced search than an exact match.
I'm confused about the query syntax on this complex a process, though I
understand this is "boolean" stuff. It's just that with multiple words AND
multiple columns, I can only envision a truly ugly query if I were to write
it with lots of CFIFs, and in the past I've gotten lost at this level.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
