Why, what's the matter with using the MAX() function? Is it anything
other than the performance load?
Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia
On Wed, 24 May 2000, Eron Cohen wrote:
> Hi Everyone,
>
> At the CFUG-orama in Washington DC last week, I think Ben Forta said that
> there is a way to avoid having to use the "MAX()" SQL function to get the ID
> number of the item you just inserted into a database. Can anyone tell me
> how to do this?
>
> In other words, currently I'm doing something like this:
>
> <CFQUERY NAME="insert_the_record" DATASOURCE="my_table">
> INSERT INTO tablename (x,y,z)
> values ('x','y','z')
> </CFQUERY>
>
> Then, to get the autonumber'ed ID of the item I just inserted, I'll use:
>
> <CFQUERY NAME="get_the_newest_record" DATASOURCE="my_table">
> Select Max(ID) as the_newest_record
> >From Tablename
> </CFQUERY>
>
> Now I'll have the ID number of the newest inserted record in
> #get_the_newest_record.newest_record#.
>
> If I understood Ben correctly, then there is a way to insert the record AND
> return the ID number of that inserted record all at the same time.
>
> The database in question is a SQL Server database. (Although it would be
> good to know how to do it with MS Access if its possible).
>
> Thanks,
>
> Eron
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
