Hello. I'm trying to get this cfquery to match a database field EXPIRATIONDATE(date) 2012-3-04 and do a recordcount but it is not working.
<cfset mydatetime= DateFormat(Now(), 'yyyy-mm-dd')> <cfquery name="data" datasource="mydata"> SELECT EXPIRATIONDATE FROM COUPONS WHERE EXPIRATIONDATE = <cfqueryPARAM value = "mydatetime" CFSQLType = 'CF_SQL_VARCHAR'> <cfoutput>#data.RecordCount#</cfoutput> Thanks, barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm