Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 13594 invoked by uid 500); 2 Jul 2001 23:14:34 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 13583 invoked from network); 2 Jul 2001 23:14:33 -0000 Subject: ESQL HACKERS: help on esql, transactions, and nested queries From: =?ISO-8859-1?Q?Rams=E9s?= Morales To: cocoon-users@xml.apache.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 02 Jul 2001 18:11:10 -0500 Message-Id: <994115471.2160.0.camel@adsl97.24-pool-143.cwpanama.net> Mime-Version: 1.0 X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N Hi. I'm starting a transaction on the main esql connection (BEGIN TRANSACTION). On that same connection I'm doing a SELECT on a table (table X). Inside the row-results of that SELECT I'm doing a nested connection, on that nested connection I'm doing a DELETE query on "table X". Will the "BEGIN TRANSACTION" on the main connection will stop my nested DELETE from working? Do I have to move BEGIN TRANSACTION to the nested connection? Do I have to do a BEGIN TRANSACTION on the main connection and on the nested connection? Thanks for your help. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: