Thank you, its working. The only change i made verifing whether the list was existed or not.
Raj ><cfquery> > SELECT > columns > FROM > prds > WHERE > <cfloop list="#myList#" index="idx"> > prds.title LIKE <cfqueryparam value="%#idx#%" >cfsqltype="cf_sql_char" /> > OR > </cfloop> > 1=1 ></cfquery> > > >-- >Charlie Griefer > >================================================ >"...All the world shall be your enemy, Prince with a Thousand Enemies, >and whenever they catch you, they will kill you. But first they must catch >you, digger, listener, runner, prince with a swift warning. >Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
