[cfaussie] Re: Whats your Primary Key?

Brett Payne-Rhodes Wed, 11 Feb 2004 18:31:30 -0800

Great! I really didn't think you could. I'll have to try it out...

Many thanks,

Brett
B)

Taco Fleur wrote:

Yup...
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:21 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Whats your Primary Key?

Can you do an Insert and a Select in a single cfquery?

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
---
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

[cfaussie] Re: Whats your Primary Key?

Reply via email to