Hmmm - this will return NO results, though I know the terms I'm looking for exists:
WHERE CAST(feature_text as VARCHAR) like <cfqueryparam value="%#form.searchTERM#%" cfsqltype="CF_SQL_VARCHAR" /> > <cfquery name="features"> > SELECT > id_feature, > feature_headline, > feature_date, > year(feature_date) as theYEAR, > CAST (feature_text AS VARCHAR ) > FROM feature > WHERE feature_headline in > <cfqueryparam value="#mylst#" cfsqltype="CF_SQL_VARCHAR" list="yes" /> > <cfloop list="#mylst#" index="i"> > OR CAST(feature_text as VARCHAR) like > <cfqueryparam value=""%#i#%"" cfsqltype="CF_SQL_VARCHAR" /> > </cfloop> > ORDER BY feature_date desc > </cfquery> __________ Information from ESET NOD32 Antivirus, version of virus signature database 5138 (20100522) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
