Subject | RE: RE: [firebird-php] auto increment last insert |
---|---|
Author | Johan van Zyl |
Post date | 2004-11-24T23:32:23Z |
Hi
[Non-text portions of this message have been removed] ??
Did I miss something here?
Cheers
JVZ
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 25 November 2004 01:17
To: firebird-php@yahoogroups.com
Subject: RE: [firebird-php] auto increment last insert
Basically, a set-by-step approach to replacing MySQL's autoinc, without
procedures, triggers, and trying to get the value after the insert(could
be
inaccurate if the generator's been used since the insert...)
[Alan McDonald] Nigel I don't think this is correct. The MySQL return of
the
last insert ID is done on a connection by connection basis. If you remain
connected between tne insert and the query for lastinsert value, noone
else
can ever get that value.
Alan
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 2004/11/19
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed] ??
Did I miss something here?
Cheers
JVZ
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 25 November 2004 01:17
To: firebird-php@yahoogroups.com
Subject: RE: [firebird-php] auto increment last insert
Basically, a set-by-step approach to replacing MySQL's autoinc, without
procedures, triggers, and trying to get the value after the insert(could
be
inaccurate if the generator's been used since the insert...)
[Alan McDonald] Nigel I don't think this is correct. The MySQL return of
the
last insert ID is done on a connection by connection basis. If you remain
connected between tne insert and the query for lastinsert value, noone
else
can ever get that value.
Alan
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 2004/11/19
[Non-text portions of this message have been removed]