errr OK:) ----- Original Message ----- From: "Matt Horn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 2:39 PM Subject: Re: [ cf-dev ] SQL INSERT INTO
> 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] -- ** 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]
