I have a text field that contains saved search criteria. The field is called CRITERIA. I need to take the criteria in the field and make a valid SQL query out of it. For example, I have a record in the table that has the following in the CRITERIA field:
My string is: AUTHOR='GIESEMAN','SMITH', ABSTRACT='CAT','DOG','FISH' I want to find all the records that have either GIESEMAN or SMITH as the author AND where abstract contains either CAT, DOG or FISH. How can I auto-magically parse the string into a valid SQL query? Athelene Gieseman Chief Information Officer Stinson Morrison Hecker [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This communication is from a law firm and may contain confidential and/or privileged information. If it has been sent to you in error, please contact the sender for instructions concerning return or destruction, and do not use or disclose the contents to others. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
