and prds.title IN (<cfqueryparam... ) On 8/1/07, ch g <[EMAIL PROTECTED]> wrote: > > what's wrong with this code.... > > <cfset keyword = "test,test1"> > > <cfquery name='getdata' datasource='abcde'> > SELECT * from prds > WHERE 1 = 1 > and prds.title like <cfqueryparam cfsqltype="cf_sql_varchar" > list="true" value="#keyword#"> > </cfquery> > > I am trying to get data from database with those two key words, if any > title has the keyword test or test1 pull that data, i don't know what i am > missing... > > Thanks > Raj > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:285077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
