Forum Discussion

raultellez17's avatar
raultellez17
Frequent Visitor
10 years ago

How to add an IN PARAMETER Type TimeStamps in Stored Procedures calls?

I'm having problems calling a stored procedures from script, the error ocurred exactly when I try to add an in parameter type DBtimestamp.   this is the code: var SProc; SProc = ADO.CreateADOSt...
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
10 years ago

What error did you get?  The exact message will help us help you.

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    10 years ago

    The error message would help, for sure... but question: You are apparently assigning a full date and time to the parameter. Shouldn't you be using adDBTimeStamp instead? I'm not sure if that would cause your error, but it seems odd to be using a time only datatype when you are passing in a full date time