> From: Lee Surma [mailto:[EMAIL PROTECTED]]
>
> I have a user that has requested the ability to search a flat file, across
8 different columns in
> any combination. My first thought is that it would require a nightmarish
amount of conditional
> logic. They currently have a form page that allows them to enter search
criteria on any ONE of the
> 8 columns, not any combination. Are there any creative solutions out
there?
I'm probably missing something here, but wouldn't a multiple field WHERE
clause in your query
do what you want? You can mix '=', 'contains', '!=', etc to generate
include and not include
logic. Allow the user to select the search logic.
query stuff
WHERE field1 #logic1# '#value1#' AND field2 #logic2# '#value2#' AND...
other query stuff
Lon Lentz
Applications Developer - GetLists.Com
DataWarehousing and List Sales - Market your lists on the Net!
[EMAIL PROTECTED]
941-541-9000 Ext. 210
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
