Received: from csunb.mit.csu.edu.au (csunb.mit.csu.edu.au [137.166.16.1]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAU12it82314 for ; Wed, 29 Nov 2000 20:02:45 -0500 (EST) (envelope-from ahexse01@postoffice.csu.edu.au) Received: from postoffice.csu.edu.au (postoffice.csu.edu.au [137.166.201.112]) by csunb.mit.csu.edu.au (8.11.0/8.11.0) with SMTP id eAU11wM16055 for ; Thu, 30 Nov 2000 12:01:58 +1100 (EST) From: "Astrid Hexsel" Reply-to: ahexse01@postoffice.csu.edu.au To: pgsql-sql@postgresql.org Date: Thu, 30 Nov 2000 12:01:59 +1100 Subject: delete rows X-Mailer: DMailWeb Web to Mail Gateway 2.5e, http://netwinsite.com/top_mail.htm Message-id: <3a25a707.6e2e.0@postoffice.csu.edu.au> X-User-Info: 137.166.125.25 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/283 X-Sequence-Number: 314 Hello All, After trying for two weeks to delete more than one row at the time from a form - checkbox input, I was told that the only way different rows would be inputed or changed with the information from the form would be with the INSERT command. This way the best alternative I could think of, would be to still have my table cart: For eaxmple: session_id|range_id|colour_id| ------------------------------ 122 | 4004-4 | 4002 122 | 4004-4 | 4003 122 | 4004-4 | 4004 which contains all the items added to the cart. Then when a deletion is required, the information from the form would be inserted into "cartchange table": For example: session_id| colour_id|condition| --------------------------------- 122 | 4001 | yes 122 | 4002 | yes Now what I am trying to do is to delete the rows from cart that appear in the cartchange table. I have tried to join the tables , but I could not find the right query to delete similar rows. Am I missing something here ? Any help will be extremely appreciated. :) Astrid