I'm using the command object to insert and update info to a SQL Server database. I need to have a decimal on one of my parameters, and I'm encountering this problem:
"The precision is invalid."
Here's my parameter:
.Parameters.Append = .CreateParameter("@TotalHo
, adDecimal, adParamInput, 9, Request.Form("txtTotalHour
My stored procedure declaration is:
@TotalHoursWorked decimal(9,2) = NULL
I've never tried this before so I'm could really use any help you good folks can lend.
Thank you so much, friends.
University of North Florida