And what would guarantee, that there was not another user, who just
inserted another record?
laszlo
William J Wheatley wrote:
>
> you could have it Select only 1 RECORD and order by the Primary Key field
> and then you should get the last record that way.
>
> Bill Wheatley
> Director of Development
> Allaire Certified ColdFusion Developer
> AEPS INC
> Allaire ColdFusion Consulting Partner
> www.aeps.com
> www.aeps2000.com
> 954-472-6684 X303
> ICQ: 417645
>
> ----- Original Message -----
> From: "Chad Elley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, January 28, 2001 7:10 AM
> Subject: Finding last record
>
> > I am inserting a record into one of my tables in MS Access. I want to
> then
> > find the primary key(auto number) immediately after insertion. Is there
> an
> > easy way to find it?
> >
> > Thanks,
> > Chad
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
