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
[EMAIL PROTECTED]
(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=89.70.4
