I have an Access db with a field entitled "topics". This is a memo field with a comma separated list of text values, such as attitude, image, change management, etc.
When I submit a form using a drop down box to pick the word "attitude", how do I set up the query on the results page to loop through all the records in that field to find and output the results of the word "attitude"? (I need to return all fields in the db for display purposes, such as name, address, etc.) <cfquery name = "q_foo" datasource = db1" SELECT * from t_list ORDER BY lastname </cfquery> <cfloop .... </cfloop> Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists