Batch updates 1

[SirLars]

hello me again
hehe

i have still not solved this problem with the batch deletes/updates using text delimited sets....

here is my code

dim playerstodelete, playerstoconfirm

playerstodelete=Request.form("delete")
playerstoconfirm=Request.form("confirm")

dim itstrue
itstrue="True"
sql = "SELECT From Results WHERE ID IN (" & playerstoconfirm & ") AND (" & playerstodelete & ")"
sql2 = "UPDATE Results SET confirmed= "& itstrue &" WHERE ID IN (" & playerstoconfirm & ")"
sql3 = "DELETE FROM Results WHERE ID IN ("& playerstodelete & ")"
accessdb="/fpdb/signup" 
dim DSNstring
DSNstring= "DBQ=" & server.mappath(accessdb) & ";DRIVER={Microsoft Access Driver (*.mdb)}" 

dim objConn
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Connectionstring = DSNstring

objConn.Open 

objConn.Execute sql2
objConn.Execute sql3

objConn.Close
Set objConn = Nothing

why is this not working?

i get this error...

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

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/tournaments/template/single_elim_16/trimdbase.asp, line 33


is there a better way to do this?
i just need to delete a set of rows and change a boolean value in another column in the other set...

 

[smbure]

CAUSE
This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried.



RESOLUTION
Remove any invalid column names from the select statement.

http://support.microsoft.com/support/kb/articles/Q216/4/25.ASP

hope this helps!
smbure

 

[SirLars]

yes i saw that shortly after i posted...

and got it to work.. also noticed the problem with the boolean field.. changing it to text "yes" or "no"...

hehe
all these clumps of hair pulled out for naught eh?

hehe
tyvm for posting...

Lars