<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]
