RE: Type attributes for cfprocparam

Datetime fields have to be passed into a stored procedure as a varchar. Ryan -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 3:01 PM To: CF-Talk Subject: Type attributes for cfprocparam Hello, I am trying to pass a value of

Re: RE: Type attributes for cfprocparam

Not true. What database are you using, stas? - Original Message - From: Ryan Pieszak [EMAIL PROTECTED] Date: Friday, May 3, 2002 12:59 pm Subject: RE: Type attributes for cfprocparam Datetime fields have to be passed into a stored procedure as a varchar.Ryan -Original Message

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

RE: RE: Type attributes for cfprocparam

Okay, let me rephrase... They don't have to be, but that's how we do it, and it works fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 3:05 PM To: CF-Talk Subject: Re: RE: Type attributes for cfprocparam Not true. What database

RE: Type attributes for cfprocparam

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

RE: Type attributes for cfprocparam

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