Hi John try this, > WHERE title LIKE <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > value="%#FORM.keyword#%">
Paul On Aug 23, 2009, at 7:46 PM, John Barrett wrote: > > Hi, > I am wondering how can I use the LIKE clause while using cfqueryparam? > I have WHERE title LIKE '%#FORM.keyword#%' > how would do cfqueryparam to this? I think that it is god to always > use cfqueryparam, right? > This is done for all database interactions (add, update, delete, > insert, etc) if I am right? > I tried: > WHERE title LIKE '%' + <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > value="#FORM.keyword#"> + '%' > > but does not work > > thanks, > John > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4747 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
