>- see footer for list info -< Errrr. I think your only option here is to wrap an INSERT statement and a SELECT MAX(id_column_name) as new_id FROM table_name in a single (locked) transaction.
Access doesn't support @@IDENTITY. It's autonumber field property isn't actually exposed in any way other than via VBA and DAO which you wouldn't want to do from CF. Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote : > >- see footer for list info - > Not @@identity is not available for Access - I believe you should use MAX() > or MAXID() I cannot remember the actual syntax. > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of RichL > Sent: 09 September 2005 14:47 > To: cfdev > Subject: [CF-Dev] @@Identity in Access? > > >- see footer for list info - > Can you use this SQL feature in Access to grab the value of the identity > column after doing an insert? > I am trying it but getting an ODBC error complaining about a missing > semi-colon. > > -- > > Rich > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > > >- Hosting provided by www.cfmxhosting.co.uk - > >- Forum provided by www.fusetalk.com - > >- DHTML Menus provided by www.APYCOM.com - > >- Lists hosted by www.Gradwell.com - > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help - > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended recipient(s) please note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or call > our switchboard on +44 (0) 20 89107910. The opinions expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk - > >- Forum provided by www.fusetalk.com - > >- DHTML Menus provided by www.APYCOM.com - > >- Lists hosted by www.Gradwell.com - > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help - Steve Powell [EMAIL PROTECTED] 07971 583792 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
