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
