Re: obtaining the next sequence id in a DataObject
| From: | Marek Kilimajer | Date: | Thu, 21 Apr 2005 17:59:54 +0000 |
| Subject: | Re: obtaining the next sequence id in a DataObject | ||
| References: | 1 2 3 4 5 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-18884@lists.php.net to get a copy of this message | ||
Justin Patrin wrote:
On 4/21/05, Dan Rossi <pear@electroteque.org> wrote:*I* personaly need it with payment gateways, for example. I need the order id before it is inserted to the db, in case the payment fails.I was assuming insert called nextId too ? So wouldsnt it shoft it twice if called twice ?? :)Yes. *WHY* do you need it before the insert? Just $do->insert() and access the field using $do->sequenceField.
On 21/04/2005, at 10:03 PM, Marek Kilimajer wrote:Justin Patrin wrote:On 4/20/05, Dan Rossi <pear@electroteque.org> wrote:If it is a sequence, you can obtain it before actual insert query (and then use it in the insert query) -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpHi there, I was wondering how its possible to get the next sequence id without having to get the connection and call the nextid from there. is there such a method ?If you're talking about an autoinc field or a DB sequence, as long as the field / sequence is set up correctly it will be in the DO after you insert. Period.