Sweet! No problem. Years of wanking has given me the fortitude to plow thru OS documentation. :-)
And I'm familiar with that page-- we're old friends. There are other formats for the manual, don't know if they're any more targeted or not... there may even be a cfquickdocs type of site for mysql... that would be cool... don't know of one off hand. ** I like what you did with it, feels much cleaner than my proposed solution. Well, tally ho, what what. =] On 2/20/07, Casey Dougall <[EMAIL PROTECTED]> wrote: > > 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")#"> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4