Ahhh, that rocked. Thanks, I didn't think it was a string.
This totally works.
AND DATE_FORMAT('DateField', '%Y') = <cfqueryparam cfsqltype="cf_sql_date"
value="#DateFormat(URL.Archive, "YYYY")#">
Woot Woot, Thank you.
My problem with the mysql docs are, their really chunky. Date_Format returns
the complete datetime function sheet and not just the portion you really
need. That page is a mess, TOO much data, it did list what I need but
weeding through it was a pain.
Thanks again.
On 2/20/07, Dinner wrote:
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270268
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
