WHERE EXPIRATIONDATE = <cfqueryPARAM value = "#mydatetime #" CFSQLType = 'CF_SQL_VARCHAR'>
Sent from my Samsung Galaxy SII On Mar 4, 2012 7:54 AM, "Barry Mcconaghey" <[email protected]> wrote: > > 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:350225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
