date field in update stored procedure

[lwd]

When I try to update a date field that I've previously added to a SQL Server
table, I get ths error message: Error converting data type varchar to
datetime. I've tried using CONVERT(#Value#,SQL_TYPE_TIMESTAMP) and
#CreateODBCDateTime(Value)#, but neither works. Any help would be appreciated.

[vkunirs]

Hi

could you post your code plz.

or try to use the single quotes for the date when updating it into the table.

[ldy]

From the update form: <input name='P_Date' type='text' value='#trim(P_Date)#'
size='8' class='bodytext'> From the update template: <CFPROCPARAM type='IN'
cfsqltype='CF_SQL_DATETIME' dbvarname='@P_Date' value='#P_Date#'> Single
quotes and double quotes make no difference.

[quig06107]

I can't imagine this would give you the error you are receiving, but you don't
need the @ in teh dbvarname in the stored procedure. It's only required on the
SP end. Take that out, use double quotes and see what happens...in fact, I'll
test myself and see if I get the same error.