View Single Post
 
Old February 25th, 2005, 07:50 AM
Shibu Shibu is offline
Authorized User
 
Join Date: Aug 2004
Location: Calicut, Kerala, India.
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I believe you mind if I rewrite the code for you
deaID = request("deaID")

    sql = "update dealerships set dactive=0 where deaID=" & deaID
    set deldealer = conn.execute(sql)


    sql2 = "SELECT * FROM dealerships WHERE dactive=0"
    set rs = conn.execute(sql2)


    DO While not rs.eof
        sql3 = "INSERT INTO inactivedealerships (Blah, blah, blah) VALUES ("BLAH, BLAH, BLAH")"


        conn.execute(sql3)


        rs.MoveNext
    loop
conn.execute("Delete FROM dealerships WHERE dactive=0")


Shibu Narayanan
Software Associates