Sorry, that should have been: In your SP: CREATE PROCEDURE Test_SP @myDate as datetime
-----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 3:16 PM To: CF-Talk Subject: RE: Type attributes for <cfprocparam> We pass them in as varchars, but accept them in the sp as datetime. In your CF code: <CFSTOREDPROC PROCEDURE="Test_SP" datasource="#ds#" username="#username#" password="#password#"> <CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR VALUE="#myDate#" DBVARNAME=@myDate> </CFSTOREDPROC> In your SP: CREATE PROCEDURE Test_SP @Start_Time_Stamp as datetime Does this help? -----Original Message----- From: stas [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 3:13 PM To: CF-Talk Subject: Re: Type attributes for <cfprocparam> Do I need to cast them inside the stored procedure? Thanks ----- Original Message ----- From: "Ryan Pieszak" <[EMAIL PROTECTED]> Datetime fields have to be passed into a stored procedure as a varchar. Ryan -----Original Message----- From: stas [mailto:[EMAIL PROTECTED]] Hello, I am trying to pass a value of #createodbcdatetime(myVar)# to a stored procedure. What would be the cfsqltype for this type of variable? I've tried DATE and TIMESTAMP, both result in errors. Thanks! ______________________________________________________________________ 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