B)
Taco Fleur wrote:
Just to confirm, are you saying that any of the following are another trip to the db?
<cfquery ....> INSERT INTO ....
SELECT @@IDENTITY AS myKey </cfquery ....>
CREATE PROCEDURE ( ............ INSERT INTO ....
SELECT @@IDENTITY AS myKey
Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Payne-Rhodes
Sent: Thursday, 12 February 2004 12:03 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Whats your Primary Key?
@@IDENTITY may solve the 'lock' issue but it is still another trip to the database to actually retrieve it. Personally I don't have a problem with doing it but let's be clear about what is and is not true.
And thanks to Tim Lucas who recently brought to light the ability to use @@IDENTITY in mySQL v4+.
Brett B)
Taco Fleur wrote:
This article is 5 years old..
"The problem with these is that finding the PK value of a newly inserted record requires another trip to the server and the
DB -- and
a lock on the database file while the DB determines the last ID inserted."
This is not true for MS SQL, you simple use @@IDENTITY or SCOPE_IDENTITY
Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget Show me and I will remember Teach me and I will learn
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Yorke Hinds
Sent: Thursday, 12 February 2004 9:57 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Whats your Primary Key?
I am using SQL Server.
In 1999 Hal Helms wrote a brief article on the subject -
http://www.halhelms.com/index.cfm?fuseaction=newsletters.aug1999
Any comments regaring Hals Article?
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED] To
unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
