1 Reply Latest reply on Sep 17, 2014 8:15 AM by Carl Von Stetten

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

    chedderslam777
      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