Claude, I think he is working with dates; I think the data-type for that column in Querynew() was "date".
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, July 30, 2007 10:48 AM To: CF-Talk Subject: Re: Query of Queries date comparison ..... and yes, since you are actually working with strings, not dates, you do need quotes in WHERE date > '#DateFormat(Now(),"yyyy/mm/dd")#' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
