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