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:248182 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
