I had considered something like that, but I did not know you could modify the existing entires in the database to add commas within the CFQUERY.
Thanks for the very quick response! On 1/10/07, Gert Franz <[EMAIL PROTECTED]> wrote: > > Sure: > > look for: > > WHERE ',' + field + ',' Like '%,18,%' > > Greetings / Grüsse > Gert Franz > Customer Care > Railo Technologies GmbH > [EMAIL PROTECTED] > www.railo.ch > > Join our Mailing List / Treten Sie unserer Mailingliste bei: > deutsch: http://de.groups.yahoo.com/group/railo/ > english: http://groups.yahoo.com/group/railo_talk/ > > > > Brett Wiese schrieb: > > I need to compare a number to a list that is contained in a row in a > database, to see if it's contained within the list, and therefor include it > in the results. > > > > Using LIKE won't work in the long term beacuse it would also find 18 in > 118 for example. > > > > I could use listfind() in the output of the query, but i'd rather limit > the CFQUERY. > > > > Is there a way to do this? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
