<cfqueryparam> verifies the datatype of a query parameter, and passes the parameter as a Bind variable. So, rather than the DBMS 'guessing' as to what datatype is being passed, cfqueryparam explicitly states it. There are also some significant security reasons for cfqueryparam. http://www.macromedia.com/devnet/security/security_zone/asb99-04.html
Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 11:49 AM To: CF-Newbie Subject: Re: HELP (ASAP!!) THANKS! That worked. What exactly did I do? :) >Torrent Girl wrote: > >Try wrapping both dateformats in cfqueryparam with sql type of date and >hopefully that should sort you out. > ><cfqueryparam cfsqltype="cf_sql_date" >value="#DateFormat(MonthEnd,"mm/dd/yyyy")#"> > >Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:992 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
