Forums
This topic is locked
RECORDSET Default Value
Posted 05 Mar 2004 19:51:56
1
has voted
05 Mar 2004 19:51:56 TRACEY RAWLINGS posted:
Using ASP Dreamweaver MX 2004 Version 7.0I have defined my recordset.
I select stored procedure.
My variables come in as
Name Default Value RunTime
From_Date Request ("START_DATE"

STORED PROCEDURE
@START_DATE datetime
etc...
FORM
one text box set to "01/01/2003"
What do i put in the default value.
I tried all kinds of dates 01/01/2003 "01/01/2003" 0 1
I keep getting a error
Description=[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
for the cast for the default date
Please help
TRAWLINGS