SHUSH YOU! :D mySQL doesn suport transactions?
really wow that sucks Tom .. Sort it out ----- Original Message ----- From: "Kevin Faulkner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 3:34 PM Subject: RE: [ cf-dev ] SQL INSERT INTO > ....unless it's MySQL which doesn't support it yet!! > > Sorry, just being awkward! > > -----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] > DISCLAIMER: This e-mail is confidential and may also be legally privileged. > If you are not the intended recipient, use of the information contained in > this e-mail (including disclosure, copying or distribution) is prohibited > and may be unlawful. Please inform the sender and delete the message > immediately from your system. This e-mail is attributed to the sender and > may not necessarily reflect the views of the patsystems Group and no member > of the patsystems Group accepts any liability for any action taken in > reliance on the contents of this e-mail (other than where it has a legal or > regulatory obligation to do so) or for the consequences of any computer > viruses which may have been transmitted by this e-mail. The patsystems Group > comprises patsystems plc and its subsidiary group of companies. > > -- > ** 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]
