query access help needed

[pelegk1]

i am doing this :
SQL = "SELECT MAX(id) as lastNum FROM DonationDb "

RS.Open SQL,Conn,1,2
if request("DonationID")="" then
id=0
Else
id=int(rs("lastNum"))+1
end if
Response.Write "donationID=" & id & "&"
SQL = "INSERT INTO DonationDb SET ID='" & id & "'"

RS.Open SQL,Conn,1,2 (***)
when i try to dothe second rs.opne(***)
i get the message :
Operation is not allowed when the object is open.
why is that?>what to do?thanks in advance
peleg

[buntine]

Peleg, have a look at what your doing here...

You have used the same ADO recordSet object twice. Hence, the error message informing you that the object is already in use, or 'open'.

You need to define/set another RecordSet object or close the first one before you try to open it again.

Regards,
Andrew Buntine.

[drewex]

Use db.execute instead of open every time. Open one connection work on that

[pelegk1]

alot drewex it solved my problem!
but i have another Question :
after that select i try to do another select on another table of the DB
and i get the message
"Operation is not allowed when the object is open.
"
what o do?
cant i make 2 selections?
thanks in advance
peleg

[buntine]

Look, i already gave you the answer...

Make another recordSet object.. You cannot open the same object twice.

[pelegk1]

doing another recordSet :(

[buntine]

Post your code..