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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285050
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
