Fortsat udregning i asp!!

Hej!

Jeg skal opdatere 10 linier i en rapport, hvor der bliver udregnet nogle tal.

Rapporten bliver lavet over 2 dele, så den er lagt i database og har fået et Id når man skal til at regne ud..

Jeg fik hjælp herinde af DK_AKJ (Eller måske omvendt) til at oprette, men nu skal den altså bare opdatere!!

Jeg har prøvet mig lidt frem , men får denne fejl:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('.

/logistik/web/rma_status_show_ny.asp, line 859

----------------------------------------
Koden står her ----->
----------------------------------------
<%
Dim strConn, conn

strConn ="DSN=AGI"
Set Conn=Server.CreateObject("ADODB.connection")
Conn.Open strConn
   
quantity1 = Trim(request.form ("quantity1"))
quantity2 = Trim(request.form ("quantity2"))
quantity3 = Trim(request.form ("quantity3"))
quantity4 = Trim(request.form ("quantity4"))
quantity5 = Trim(request.form ("quantity5"))
quantity6 = Trim(request.form ("quantity6"))
quantity7 = Trim(request.form ("quantity7"))
quantity8 = Trim(request.form ("quantity8"))
quantity9 = Trim(request.form ("quantity9"))
quantity10 = Trim(request.form ("quantity10"))


'hent priser
price1 = Trim(request.form ("price_each1"))
price2 = Trim(request.form ("price_each2"))
price3 = Trim(request.form ("price_each3"))
price4 = Trim(request.form ("price_each4"))
price5 = Trim(request.form ("price_each5"))
price6 = Trim(request.form ("price_each6"))
price7 = Trim(request.form ("price_each7"))
price8 = Trim(request.form ("price_each8"))
price9 = Trim(request.form ("price_each9"))
price10 = Trim(request.form ("price_each10"))


' subtotaler
subtotal1 = quantity1 * price1
subtotal2 = quantity2 * price2
subtotal3 = quantity3 * price3
subtotal4 = quantity4 * price4
subtotal5 = quantity5 * price5
subtotal6 = quantity6 * price6
subtotal7 = quantity7 * price7
subtotal8 = quantity8 * price8
subtotal9 = quantity9 * price9
subtotal10 = quantity10 * price10


'total
total = subtotal1 + subtotal2 + subtotal3 + subtotal4 + subtotal5 + subtotal6 + subtotal7 + subtotal8 + subtotal9 + subtotal10


sql = "Update [logistikrma_test]"
sql = sql & " set"
sql = sql & "(quantity1, quantity2,quantity3,quantity4,quantity5,quantity6, quantity7,quantity8,quantity9,quantity10,price1,price2,price3,price4,price5,price6,price7,price8,price9,price10,subtotal1,subtotal2,subtotal3,subtotal4,subtotal5,subtotal6,subtotal7,subtotal8,subtotal9,subtotal10,total ) "
sql = sql & " values "
sql = sql & "(" &  quantity1 & "," & quantity2 & "," & quantity3 & "," & quantity4 & "," & quantity5 & "," &  quantity6 & "," & quantity7 & "," & quantity8 & "," & quantity9 & "," & quantity10 & ","
sql = sql &  price1 &"," & price2 &"," & price3 &"," & price4 &"," & price5 & "," & price6 &"," & price7 &"," & price8 &"," & price9 &"," & price10 & ","
sql = sql &  subtotal1 &"," & subtotal2 &"," & subtotal3 &"," & subtotal4 &"," & subtotal5 & "," & subtotal6 &"," & subtotal7 &"," & subtotal8 &"," & subtotal9 &"," & subtotal10 & ","

sql = sql &  total & ") Where Id = " & Request("Id") & ""

conn.execute (sql)
%>

Håber I kan hjælpe!!

/Bruhn