erm...unless I am too tired after the weekend...all cftransaction will allow you to do is rollback any changes should you pass in crappy code for the insert.......not really a huge big deal but it can be prevented beforehand.
Of course, we can all go and read Simon's cftransaction doc but I am sure we are all familiar with it. -----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 14:27 To: [EMAIL PROTECTED] 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]
