I checked...ran the query...same results...the data's good. Rick
-----Original Message----- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Sunday, July 30, 2006 9:55 PM To: CF-Talk Subject: Re: Anyone see anything wrong with this code? Seems obvious, but are you sure that the query should return any results? Check your debugging output, grab the SQL that is generated and run it directly on the datasource. Cheers, Kris On 7/30/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:248200 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
