Sql DELETE Hvordan?

Det er fordi du ikke kan lave joins i en DELETE. Så er du nødt til at lave 2 stk.!

//>Rune

Nu har jeg prøvet at lave følgende:

                        Sql = "SELECT R.Antal, BR.BookingRessourceID From BookingRessource as BR, Ressourcer as R Where BookingID = " & Request("BookingID") & " and  R.RessourceID = BR.RessourceID and R.Antal = 0"
                        Set rs = conn.execute(sql)
                       
                        Do while not rs.eof
                            db_BookingRessourceID             = rs("BookingRessourceID")
                           
                            Sql = "DELETE From BookingRessource Where BookingRessourceID = " & db_BookingRessourceID
                            Set rs = conn.execute(sql)
                           
                            rs.movenext
                        Loop

Men det giver mig følgende fejl:
Operation is not allowed when the object is closed.

Sql = "SELECT R.Antal, BR.BookingRessourceID From BookingRessource as BR, Ressourcer as R Where BookingID = " & Request("BookingID") & " and  R.RessourceID = BR.RessourceID and R.Antal = 0"
                        Set rs = conn.execute(sql)
                       
                        Do while not rs.eof
                            db_BookingRessourceID            = rs("BookingRessourceID")
                           
                            Sql = "DELETE From BookingRessource Where BookingRessourceID = " & db_BookingRessourceID
                            conn.execute(sql)
                           
                            rs.movenext
                        Loop

//>Rune

Thx 4 Poinz

//>Rune