update sql problem 1

[xue]

I am trying to update the quantity on cartitems table:

Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + '" & CtempQty & "' WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot
actually concat strings, so instead of 3+3, now it is 33

Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + & CtempQty & WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot
gives syntax error near & error message

Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + "& CtempQty &" WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot or
Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + '& CtempQty &' WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot
are both not working, but:
Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + 1 WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot
does increment 1 to the quantity(Qty).

so how can I add the CtempQty, which is the request.form("qty&quot to the quantity, which is Qty to the table? thank you very much.

 

[Antzz]

Ok, this is what you have :
In the following query there is a syntax error - you have quotes surrounding the variable CtemQty.
Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + '" & CtempQty & "' WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot

That was the first query. In fact I did find syntax errors in all the queries. What you need to do is something like this :

Set rs3 = conn.Execute("UPDATE CartItems SET Qty = Qty + " & CtempQty & " WHERE Cartid = '" & cartID & "' And Productid = '" & s & "' &quot


Lemme know if it worked.

 

[Guest_imported]

sorry to get back to you so late. yes, it works. thank you very much. the problem is I need to have space between " and &
it just have to be so precise, huh.