ok, great. I understand conceptually. I've not done it beore but I'll give it a "college try" :-) thanks for the guidance.
>I would do a sub-query where you union the same query on each column, >and then query that. > >|I have a db that contains 6 similar columns: line_1, line_2 , >|line_3 , line_4 , line_5 , line_6 I want to have a search that >|searches across columns. While I can search them >|individually, it would be better if they were combined before >|the LIKE was done so that if I had: >|line_1="I need to" >|line_2="go to the bathroom" >|and I searched "need to go", it would return a hit. >| >|I'm not sure how to approach this but while I have a >|beginning, I know that it is incorrect because it's the first >|type of search, searching each line individually. >| >|<cfquery name="getSearchItem" datasource="dpch"> >| SELECT >|recipients_lname,recipients_fname,recipients_mi,leaf_number >| FROM giving_leaves >| WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' >|</cfquery> >| >|thanks for the help. >| >|-- >|Daniel Kessler >| >|Department of Public and Community Health University of >|Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 >|301-405-2545 Phone >|www.phi.umd.edu >| >| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188560 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
