Just putting in <cfqueryparam cfsqltype="CF_SQL_DATE" Value="#CreateODBCDate(Form.Start_Date)#"> threw an error.
Using <cfqueryparam cfsqltype="CF_SQL_DATE" Value="#DateFormat(CreateODBCDate(Form.Start_Date), "mmm d, yyyy")#"> made CF and MySQL happy. And that makes me happy. :o) Don't need the #'s around the formfields, "Form.Start_Date" and "Form.End_Date" ? Rick -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Sunday, July 30, 2006 9:35 PM To: CF-Talk Subject: Re: Anyone see anything wrong with this code? 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:248188 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
