«

How does one paramtized a date in asp for a stored procedure that is
expecting DateTime?


if oRS.eof then
'// SAFE TO INSERT STORY....

CREATE Procedure spr_AddStory

oCmd.Parameters.append oCmd.CreateParameter("StoryTitle", adVarChar,
adParamInput,100,pStoryTitle)
oCmd.Parameters.append oCmd.CreateParameter("StoryDate datetime,
'//??????????????)

Thanks
Jason

wrote:
> How does one paramtized a date in asp for a stored procedure that is
> expecting DateTime?
>
>
> if oRS.eof then
> '// SAFE TO INSERT STORY....
>
> CREATE Procedure spr_AddStory
>
> oCmd.Parameters.append oCmd.CreateParameter("StoryTitle", adVarChar,
> adParamInput,100,pStoryTitle)
> oCmd.Parameters.append oCmd.CreateParameter("StoryDate datetime,
> '//??????????????)
>
> Thanks
> Jason

The correct datatype constant is adDBTimeStamp.

You might want to try out my code generator available here:
http://www.thrasherwebdesign.com/ind...asp&c=&a=clear

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

wrote:
> How does one paramtized a date in asp for a stored procedure that is
> expecting DateTime?
>
> oCmd.Parameters.append oCmd.CreateParameter("StoryDate datetime,
> '//??????????????)

The complete list is here:
http://msdn.microsoft.com/library/en...tatypeenum.asp



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.