Re: Cfquery dates help needed
> CFSQLType ='CF_SQL_VARCHAR'> Also for date columns use a date/time type instead of varchar. If the column contains dates (only) you can use cf_sql_date, which truncates the time portion. WHERE EXPIRATIONDATE = http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Cfquery dates help needed
WHERE EXPIRATIONDATE = Sent from my Samsung Galaxy SII On Mar 4, 2012 7:54 AM, "Barry Mcconaghey" 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. > > > > > SELECT EXPIRATIONDATE > FROM COUPONS > WHERE EXPIRATIONDATE = 'CF_SQL_VARCHAR'> > > #data.RecordCount# > > 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
Cfquery dates help needed
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. SELECT EXPIRATIONDATE FROM COUPONS WHERE EXPIRATIONDATE = #data.RecordCount# 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