Varialbe into and integer? RRS feed

  • Question

  • User-874058733 posted

    hi all...

    i have a variable that contains a total figure from other variables (loyaltypoints -  LoyalDiscount*100 + objCart.SubTotal)

    My new variable is called pointsupdate and i want to use this calcualtion figure to update a sql table field.

    I'm getting all the right calculations written to the page, but the update just won't work.

    If i swap the varialbe (pointsupdate) for a typed in number, the update works fine.

    Could someone advise please?

    Thanks in advance


    Thursday, September 5, 2013 10:13 AM


  • User1183424175 posted


    You can try enclosing the expression "loyaltypoints -  LoyalDiscount*100 + objCart.SubTotal" with brackets. But I think we should better use the variable(pointsupdate) instead of calcualtion figure.

    Hope it can help you.

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, September 6, 2013 5:41 AM