simple delete recordset

Results 1 to 2 of 2

Thread: simple delete recordset

  1. #1
    Join Date
    Dec 1969

    Default simple delete recordset

    i am simply trying to delete all recordsets that match my filter. i found the syntax for such an operation however i am getting an error msg: operation not allowed.<BR><BR>my asp looks a little like this:<BR><BR>SQL=" SELECT * FROM Order_Detail_Table "_<BR> &" WHERE ORD_Order_Number=" &SESSION("ordernum")<BR> SQL<BR>rst1.delete 2<BR>rst1.close<BR><BR>what am i doing wrong?

  2. #2
    Join Date
    Dec 1969

    Default Opening recordset wrong...

    You aren&#039;t opening an updatable recordset.<BR><BR>But why do it that error-prone way:<BR><BR>*MUCH* faster to do:<BR><BR>&#060;%<BR>SQL="DELETE FROM Order_Detail_Table WHERE ORD_Order_Number=" &SESSION("ordernum")<BR>conn.Execute( SQL )<BR>%&#062;<BR><BR>No recordset object needed or wanted!<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts