The value returned from the qry_order_commit_1 function is not of type numeric.

New Here ,
Sep 16, 2014 Sep 16, 2014

Copy link to clipboard

Copied

declare@orderKey int
INSERT#request.sqlObjectPrefix#tblOrders (
tblPeopleFK
,shippingMethod
,shippingCost
,insurancecost
,shippingtotal
,shippingWeight
,itemSubtotal
,tax
,totalBeforeTax
,total
,orderStatus
,payment_method

                        ,cfuserid

)
SELECT<cfqueryparam value="#val(arguments.app_user_id)#" cfsqltype="CF_SQL_INTEGER">
,oib.shippingMethod
,oib.shippingCost
,oib.insuranceamount
,( oib.shippingCost + oib.insuranceamount )
,oib.shippingWeight
,<cfqueryparam value="#val(arguments.item_subtotal)#" cfsqltype="CF_SQL_MONEY">
,<cfqueryparam value="#val(arguments.tax)#" cfsqltype="CF_SQL_MONEY">
,<cfqueryparam value="#val(arguments.total_before_tax)#" cfsqltype="CF_SQL_MONEY">
,<cfqueryparam value="#val(arguments.total_total)#" cfsqltype="CF_SQL_MONEY">
,<cfqueryparam value="1" cfsqltype="CF_SQL_INTEGER">
,<cfqueryparam value="#arguments.payment_method#" cfsqltype="CF_SQL_VARCHAR">
,<cfqueryparam value="#arguments.cfuserid#" cfsqltype="CF_SQL_VARCHAR">
FROM#request.sqlObjectPrefix#tblOrderInfoBuffer oib
WHEREoib.tblPeopleFK = <cfqueryparam value="#val(arguments.app_user_id)#" cfsqltype="CF_SQL_INTEGER">
SET NOCOUNT ON
SELECT@orderKey = SCOPE_IDENTITY()
SET NOCOUNT OFF
SELECT @orderKey as orderKey

Views

153

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Sep 17, 2014 Sep 17, 2014

Copy link to clipboard

Copied

LATEST

Stacktrace?  Where is the qry_order_commit_1 function code?  We need more information to be able to assist you.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines