|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Batch/multiple UPDATE with QueryString |
|
From: |
Patrick Arkley |
|
Date: |
6/30/2003 10:22:41 AM |
|
IP: |
62.191.140.162 |
This is how my QueryString looks like:
http://.../showres.asp?resid=69&place69=1&points69=
1&lap69=1.34.67&resid=68&place68=1&points68=8&lap68=1.36.77...etc
This is the code I´ve put before HEAD:
DIM place
DIM points
DIM lap
DIM resid
FOR EACH fld IN Request.QueryString
IF left(fld,5)="resid" then
resid=right(fld,len(fld)-5)
Set Conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "gokartDSN"
sSQL=UPDATE Resultat SET place=" & request.QueryString("place" & resid) & ",points=" & Request.QueryString("points" & resid) & ",lap=" & Request.QueryString("lap" & resid) & " WHERE resID=" & resid
Conn.execute sSQL
END IF
NEXT
This is the error message I get:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/aspcit/showres.asp, line 33
*
sSQL=UPDATE Resultat SET place=" & request.QueryString("place" & resid) & ",points=" & Request.QueryString("points" & resid) & ",lap=" & Request.QueryString("lap" & resid) & " WHERE resID=" & resid
The star above the R is the marker for the errormessage.
The UPDATE-string is qbviously wrong but I can´t find out what it could be.
Please help me.
__________________
Rgds
Patrick Arkley
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
