yep, I am fully aware of what cftransaction does - I dont use it myself, as we use SP's here...but I think for this its overkill.
-----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 14:30 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL INSERT INTO Niel cfTransaction allows Rollbacks should there be an error on the insert I see what you are saying that this should never happen because all the input should be validated but if the database crashes after the 1st query .. you will end up having orphined data therefor CFtransaction is ALWAYS a good idea when inserting related data into multiple tables ----- Original Message ----- From: "Steve Martin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 3:27 PM Subject: RE: [ cf-dev ] SQL INSERT INTO Sure, but as CFTRANSACTION doesn't have anything to do with validation ;-) ... Anyone else care to explain? I can't be bothered. Steve > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 14:05 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL INSERT INTO > > > Is there a need for a transaction? surely the data being > passed into the > insert will already be validated client and server side. > > -----Original Message----- > From: Steve Martin [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 13:49 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL INSERT INTO > > > <cftransaction> > > <Your Insert Query here> > > SELECT Max(id) as SomeIDName > FROM XXXX > > > </cftransaction> > > Steve > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 14 July 2003 13:44 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] SQL INSERT INTO > > > > > > Hi, > > > > I am using an Access DB and am using the INSERT INTO > > statemeant to add an > > entry to a table, how do i get the ID for the entry that I have just > > inserted (the Autonumber). I am currently using a second > > SELECT query to > > retrieve the field using the values that were inserted, but > > this doesn't > > look tidy and has possible problems (integrity and performance), > > > > Thanks, > > > > Chris Cormack > > > > British Telecommunications plc > > Registered office: 81 Newgate Street London EC1A 7AJ > > Registered in England no. 1800000 > > This electronic message contains information from British > > Telecommunications > > plc which may be privileged or confidential. The information > > is intended to > > be for the use of the individual(s) or entity named above. If > > you are not > > the intended recipient be aware that any disclosure, copying, > > distribution > > or use of the contents of this information is prohibited. > If you have > > received this electronic message in error, please notify us > > by telephone or > > email (to the numbers or address above) immediately. > > Activity and use of the British Telecommunications plc E-mail > > system is > > monitored to secure its effective operation and for other > > lawful business > > purposes. Communications using this system will also be > > monitored and may be > > recorded to secure effective operation and for other lawful business > > purposes. > > Any views expressed in this email do not reflect those of BT > > and any of > > partners and assosiates. Responsiblity for the opinions > > expressed are those > > of the sender only > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
