Yep, the only problems I find with UUID's (and since my Spectra days) is that they are a real bitch to remember!
-----Original Message----- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 13:57 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL INSERT INTO ....Agree with the second option, I always try and avoid autonumber and increment, they seem to cause more problems than they solve, keep the code in your hands I always say! You've also got a better system which is easier to migrate when the time comes.... -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 13:51 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL INSERT INTO or to expand, you could get around the second query by not using autonumbers and creating a UUID before you insert - that way you will have a unique record and the key all in one handy stint. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 13:46 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL INSERT INTO after the call : simply do another query and use SELECT MAX(ID). Remember and use locks around that one in case another record gets inserted before it can run. -----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] 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]
