[thelist] coldfusion,mysql - record locking?

Jay Greenspan jay at trans-city.com
Mon Oct 29 12:15:37 CST 2001


just run the last_insert_id function() within a query: "SELECT 
last_insert_id()". It returns the last auto_increment value generated by 
a specific thread. Don't worry about the locking.

-j

On Monday, October 29, 2001, at 01:08 PM, Bimal Shah wrote:

> We have a record locking issue, we are using MySQL with
> Coldfusion and have one or more queries on different pages
> which are updating,adding or removing from a number of tables.





More information about the thelist mailing list