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.0

I 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

Reply to this topic