Don't forget to wrap the CFQUERY doing the INSERT and the CFQUERY
doing the SELECT with a CFTRANSACTION tag.
Tom
At 7/23/00 01:48 AM, you wrote:
>Or, would you lock the tables used in the set of queries that include the
> > SELECT Max(ID) AS mid FROM Table_Name?
>
>Sorry, still thinking aloud.
>
>Stephen R. Cassady
>Publisher, Spank! Youth Culture Online
>http://www.spankmag.com
>[EMAIL PROTECTED]
>
> > If I understand you correctly, you need the "autonumber" that was just
> > created when you inserted data into your db. If this is correct, try this:
> >
> > <cfquery name="name" datasource="datasource">
> > SELECT Max(ID) AS mid FROM Table_Name
> > </cfquery>
> >
> > Hope that helps...
> >
> > Mark
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>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.mail-archive.com/cf-talk@houseoffusion.com/
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.
