mySQL database. I need a way in MS SQL to get the last inserted record
via CF. I have a query inserting a row into the table with an
auto-increment ID. I need to insert that ID into a separate table in
another query so I first need to find out what ID it got assigned. I've
got it all wrapped in <cftransaction> but I'm not sure if max(id) is the
best way to get the ID, because if rows get deleted, won't SQL
automatically assign those values to new rows at some point, therefore
negating the max() idea?
John Burns
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
