I am using ColdFusion MX 7.0 with a MySQL database. One of my tables has an autoincrement field called "intKey" (without the quotes, obviously) as the key.
Is there a way to programatically determine the number of the next record that will be added to the database? For example, if I have ten records (with keys of 1 through 10) and I delete records 8, 9, and 10, the next record that will be inserted will be 11. Therefore it's not a matter of using the Max(intKey) function and adding 1, because that would say that the next record will be 8 instead of 11. Is there something I am missing here? Thanks! Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3169 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
