Highlighted

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

New Here ,
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

147

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

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

New Here ,
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

148

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
Sep 16, 2014 0
Most Valuable Participant ,
Sep 17, 2014

Copy link to clipboard

Copied

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
Reply
Loading...
Sep 17, 2014 0