Passing decimal(price) to stored procedure

[federalist]

I'm new to all this, but I have to make a prototype of a legacy system I worked on.

Using ASP to present the info to the user I have an INPUT field that will be used to display and update a price, defined as a decimal(7,2) in a SQL Server 2000 database.

When I create the parameter to pass to the stored procedure, I have used

curPrice = CDBL(TRIM(request("txtPrice&quot)) and then create the parameter to pass to the stored procedure using the variable:

cmdParts.Parameters.Append cmdParts.CreateParameter ("@PRICE", addecimal, adParamInput, , curPrice)

I also tried it like this:

cmdParts.Parameters.Append cmdParts.CreateParameter ("@PRICE", addecimal, adParamInput, , CDbl(Trim(request("txtPrice&quot)))

The stored procedure has the parameter defined as

REATE PROCEDURE ADD_ITEM_DETAIL
(@ITEMSEQ Int
,@ITEMDETAILDESC varchar(50)
,@PRICE decimal(7,2)
,@REQUIRED char(01)
,@ACTIVE char(01)
)

and the field is defined in the database as a decimal(7,2)

And I get this....

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/CE/Maintenance/Plans/UpdatePlanCodeInfo.asp, line 93


I've removed all references to the 'price' and I can add rows without a problem.

So... how do you get a price (7.25) from the HTML to the stored procedure and get it updated? Somewhere on the way it appears I am encountering a data type conversion problem of some kind.

I've tried to redefine the field as Money vs. decimal.

Regards.

 

[mwolf00]

This should work.... How are you unsing the value in the SP?

curPrice = TRIM(request("txtPrice&quot)

cmdParts.parameters(2) = curPrice

....

CREATE PROCEDURE ADD_ITEM_DETAIL
(@ITEMSEQ Int
,@ITEMDETAILDESC varchar(50)
,@PRICE money
,@REQUIRED char(01)
,@ACTIVE char(01)
)

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[federalist]

In the stored procedure I am inserting a row into a table.

Insert into tblItemDetail
...
Price,
...

Values
(...
,@PRICE)
...
)

 

[mwolf00]

Everything still looks alright here, what dataType is Price in your database?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[federalist]

it is decimal(7,2)