Why don't you use a join table via which to associate your items and categories?
Josh -----Original Message----- From: Patrick Forsythe [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 1:47 PM To: CF-Talk Subject: Re: Query problem with lists of values that is kind of what I thought, but is there any way around this? >This is happening of course because two of your like clauses "catid LIKE '#uid#' AND catid LIKE '#uid#,' means that the 2 will match the 2 in '52,'. This is the difficulty with this kind of set up. > >-- >Patrick Forsythe >Tech Support >Smallville Communications >http://www.toto.net > >"Guter Rat ist teuer." --Unbekannt > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
