Change: <cfprocparam cfsqltype="cf_sql_date" dbvarname="@Date_Registered" type="in" value="#Today#">
To: <cfprocparam cfsqltype="cf_sql_timestamp" dbvarname="@Date_Registered" type="in" value="#CreateODBCDate(Today)#"> The MS SQL Server drivers that ships with CF is pretty brain dead for passing date/time values via cfprocparam and cfqueryparam. Basically any date/time types other than cf_sql_timestamp will crap out. ---------------------------- James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 9:51 AM To: CF-Talk Subject: Re: What does this mean? I'm guessing that the problem is in the stored proc and that you're doing something not supported by the Merant JDBC drivers. If you can post the actual stored procedure, maybe someone will see the problem for you. On 8/3/02 8:48 AM, "Bruce Sorge" <[EMAIL PROTECTED]> wrote: > I searched the on-line docs and the MM site and I cannot find out why I > am receiving this error. > > > > > MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server > Driver]Optional feature not implemented > > > > > > > > The Error Occurred in C:\Web\WME\voucher\step_2_Insert.cfm: line 51 > > > 49 : <cfprocparam cfsqltype="cf_sql_varchar" > dbvarname="@VoucherCode" type="in" value="#Session.VoucherCode#"> > 50 : <cfprocparam cfsqltype="cf_sql_date" > dbvarname="@Date_Registered" type="in" value="#Today#"> > 51 : </cfstoredproc> > 52 : </cftransaction> > 53 : > > > > > > > > Anyone else encounters this and can you tell me what the resolution is? > I am using CFMX. > > > > > > Thanks, > > Bruce > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
