Definately use Cfqueryparam:

<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 >= <cfqueryparam cfsqltype="CF_SQL_DATE" value="
Form.Start_Date">
    and Client_Birthdate <= <cfqueryparam cfsqltype="CF_SQL_DATE" value="
Form.End_Date">
</CFQUERY>

--
Richard Dillman
rdillman@gmai...
(317) 916-8341

"IF-THEN-ELSE  its a way of life!"


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