Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2E96047590C for ; Sat, 9 Nov 2002 16:03:38 -0500 (EST) Received: from hotmail.com (f6.law12.hotmail.com [64.4.19.6]) by postgresql.org (Postfix) with ESMTP id 775864758FE for ; Sat, 9 Nov 2002 16:03:37 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 9 Nov 2002 13:03:50 -0800 Received: from 128.123.37.105 by lw12fd.law12.hotmail.msn.com with HTTP; Sat, 09 Nov 2002 21:03:50 GMT X-Originating-IP: [128.123.37.105] From: "Zhidian Du" To: bruno@wolff.to Cc: pgsql-php@postgresql.org Subject: Re: Transaction including two web page + timer Date: Sat, 09 Nov 2002 14:03:50 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 09 Nov 2002 21:03:50.0715 (UTC) FILETIME=[80E758B0:01C28833] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/41 X-Sequence-Number: 1623 Good idea. One problem is that HTML is a stateless protocol. How can I let application to hold the whole contents of the first page and second page? Thanks. Z. Du >From: Bruno Wolff III >To: Zhidian Du >CC: pgsql-php@postgresql.org >Subject: Re: [PHP] Transaction including two web page + timer >Date: Sat, 9 Nov 2002 09:59:04 -0600 > >On Sat, Nov 09, 2002 at 00:04:26 -0700, > Zhidian Du wrote: > > > > I have a question of, when users input some contents in the second page, > > then the contents in first and second pages are inserted into tables; > > Otherwise, rollback. > > > > I want to use transction to handle it. > > > > But when users input the contents in first page, how do I know users >have > > left( My program will roolback ) or want to continue input sone contents >in > > the second page (comit)? Usig timer, for example? or some other better > > idea. > >My suggestion would be not to start entering either page until the >application >has all of the data for both pages. Holding transactions open for long >periods of time is not a good idea. > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail