Thanks, Tom...the use of between may solve one problem I had with the actual working of the app, which was when the user would ask for birthdates on or between two dates (month and day) that spanned a month, no results would be returned.
However, wouldn't "between" only dates actually "between" two specified dates (month and day), excluding the specified dates themselves. E.g. Need birthdates fall on or between Nov 27 and Dec 3. Using >= and <= provides me with birthdates on Nov 27 and Dec 3, also. Would between exclude Nov 27 and Dec 3? Rick PS - And this was a query run into a query editor directly on an MySQL DB, not involving CF...just needed to extract some info, since my client can't access the web app for some reason online... -----Original Message----- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 11:08 AM To: CF-Talk Subject: Re: How can I make this query run correctly? On Wednesday 22 November 2006 15:46, Rick Faircloth wrote: > from clients > where Client_Birthdate >= '2006-11-27' > and Client_Birthdate <= '2006-12-31' where client_birthdate between <cfqueryparam value="#dateOne#" ... > and <cfqueryparam value="#dateTwo#" ... > Between is a handy SQL shortcut, and the use of cfqueryparam with real CF dates leaves formatting it correctly where it belongs, well belowe the level you need to care about. -- Tom Chiverton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
