|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Updating multiple records |
|
From: |
Paul DeBenedittis |
|
Date: |
2/24/1999 11:04:38 PM |
|
IP: |
209.131.171.31 |
I have a web database with an admin section that will bring up abbreviate listing of all the records (only some of the fields). I have two checkboxes for each record that the administrator can select or deselect. I am trying to write a routine that would go through each of the records and update on one submission rather than editing one record, enter, edit another record and enter etc. My code looks like:
for each x in Request.Form
xstr=Left(Cstr(x),5) '(each form field has a 5 letter prefix and then a unique number)
if xstr = "entry" then (entrynum is the key)
entrynum= Request.form(x)
PicRec=Request.form("PicRec" & entrynum)
PicLoaded=Request.form("PicLoaded" & entrynum)
objRS.Filter="[entrynum] = '" & entrynum & "'"
if PicRec = "on" then
objRS("PicRec")=1
else
objRS("PicRec")=0
end if
if PicLoaded="on" then
objRS("PicLoaded")=1
else
objRS("PicLoaded")=0
end if
objRS.Update
end if
next
I get the following error:
ADODB.Field error '800a0cb3'
The operation requested by the application is not supported by the provider.
/administration/show.asp, line 95
Line 95 is the line objRs("PicRec")= 1
In a very drawn out way, I have tried to provide details to the question can you have a form for multiple records and with one submission update them all. If so, does anyone see a syntax error or concept error in the above?
thanks
Paul
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
