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! ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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