Thanks, Jim...Got it figured out...I was running a query directly against MySQL DB with using CF. No results were being returned because I had the year included and no customers have been born for my client since the dates, 2006-11-27 to 2006-12-03, have even occurred yet! :oP
Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 11:16 AM To: CF-Talk Subject: Re: How can I make this query run correctly? Rick Faircloth wrote: > Good morning, all. > > I'm having to directly query a MySQL database for a client > because they can't access their web app on my server. > > I'm trying to get clients' whose birthdates fall with a date range. > > I've tried variations, with no success in returning *any* results. the > latest version of the query is as follows: > > Select Client_First_Name, Client_Middle_Name, Client_Last_Name, > Client_Street_Address, Client_City, Client_State, > Client_Zip_Code, Client_Birthdate > from clients > where Client_Birthdate >= '2006-11-27' > and Client_Birthdate <= '2006-12-31' > > Is it a date formatting issue? Is so, what is the date date format MySQL > could read? > This is a guess, but perhaps... WHERE Client_Birthdate >= CAST('2006-11-27' AS DATE) AND Client_Birthdate <= CAST('2006-12-31' AS DATE) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4