Re: Cfquery dates help needed

2012-03-04 Thread Leigh
> 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

Re: Cfquery dates help needed

2012-03-04 Thread Matt Quackenbush
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 >

Cfquery dates help needed

2012-03-04 Thread Barry Mcconaghey
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 ~~~