Rick, There are two problems with the code
Where Client_Birthdate between(Start_Date, EndDate) Now what the other problem is that can occur is that the DB field will have a time stamp and comparing a data against that will result in no records unless you append a timestamp using CreateODBCDate() HTH Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, 31 July 2006 9:58 AM To: CF-Talk Subject: Anyone see anything wrong with this code? <CFQUERY Name="Get_Clients" Datasource="#DSN#"> Select Client_ID, Client_First_Name, Client_Middle_Name, Client_Last_Name, Client_Name_Suffix, Client_Birthdate, Client_Street_Address, Client_City, Client_State, Client_Zip_Code from clients where Client_Birthdate >= '#Form.Start_Date#' and Client_Birthdate <= '#Form.End_Date#' </CFQUERY> The query seems to run and doesn't throw an error, but no results are returned.db is MySQL. ??? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248201 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
