>- see footer for list info -< Thanks very much for all the input here
On 9/14/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Coming in late here but I believe that access supports @@identity in later > versions: > > http://cfmxplus.blogspot.com/2002_07_28_cfmxplus_archive.html > > http://support.microsoft.com/default.aspx?scid=kb;[LN];Q233299 > > HTH > > kola > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:dev- > > [EMAIL PROTECTED] On Behalf Of Snake > > Sent: 10 September 2005 21:57 > > To: 'Steve Powell'; 'Coldfusion Development' > > Subject: RE: [CF-Dev] @@Identity in Access? > > > > >- see footer for list info -< > > Although I would try it to be sure, as I have a vague memory of using > the > > select max method myself for years, only to then find there was an > inbuilt > > method for Access to DO THIS. > > > > Russ > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Steve Powell > > Sent: 10 September 2005 22:15 > > To: Coldfusion Development > > Subject: RE: [CF-Dev] @@Identity in Access? > > > > >- 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<http://www.cfmxhosting.co.uk>- > > > >- Forum provided by www.fusetalk.com <http://www.fusetalk.com> - > > > >- DHTML Menus provided by www.APYCOM.com <http://www.APYCOM.com> - > > > >- Lists hosted by www.Gradwell.com <http://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<http://www.cfmxhosting.co.uk>- > > > >- Forum provided by www.fusetalk.com <http://www.fusetalk.com> - > > > >- DHTML Menus provided by www.APYCOM.com <http://www.APYCOM.com> - > > > >- Lists hosted by www.Gradwell.com <http://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<http://www.cfmxhosting.co.uk>-< > > >- Forum provided by www.fusetalk.com <http://www.fusetalk.com> -< > > >- DHTML Menus provided by www.APYCOM.com <http://www.APYCOM.com> -< > > >- Lists hosted by www.Gradwell.com <http://www.Gradwell.com> -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > > >-< > > > > > > _______________________________________________ > > > > 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<http://www.cfmxhosting.co.uk>-< > > >- Forum provided by www.fusetalk.com <http://www.fusetalk.com> -< > > >- DHTML Menus provided by www.APYCOM.com <http://www.APYCOM.com> -< > > >- Lists hosted by www.Gradwell.com <http://www.Gradwell.com> -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > > > > > _______________________________________________ > > 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<http://www.cfmxhosting.co.uk>-< > >- Forum provided by www.fusetalk.com <http://www.fusetalk.com> -< > >- DHTML Menus provided by www.APYCOM.com <http://www.APYCOM.com> -< > >- Lists hosted by www.Gradwell.com <http://www.Gradwell.com> -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > -- Rich _______________________________________________ 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 -<
