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:4746 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
