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