Question
The value returned from the qry_order_commit_1 function is not of type numeric.
| 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 | ||||
| WHERE | oib.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 |
AdChoices