> 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
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
>
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
~~~
3 matches
Mail list logo