Thanks for the input guys. Here is the solution: Changing '#Form.Start_Date#' to #CreateODBCDate(Form.Start_Date)# and the same for End_Date.
Rick -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, July 30, 2006 8:27 PM To: CF-Talk Subject: Re: Anyone see anything wrong with this code? It might come down to the date format used. You could also try a BETWEEN comparison instead. On 7/31/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > <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:248191 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
