Kurt
Member since Oct 21, 2021
- Profile: /members/14331-kurt.htm
- Comments: 2
Recent Blog Comments By Kurt
-
Creating A Group-Based Incrementing Value Using LAST_INSERT_ID() In MySQL 5.7.32 And Lucee CFML 5.3.7.47
Posted on Oct 22, 2021 at 9:45 AM
Oh nice! I had no idea LAST_INSERT_ID() could be seeded, I assumed it was always read only. Very clever trick, thanks for posting!... read more »
-
Creating A Group-Based Incrementing Value In MySQL 5.7.32 And Lucee CFML 5.3.7.47
Posted on Oct 21, 2021 at 12:31 PM
Nice post Ben! One other thing to mention that can also keep transaction/locking/latency low is to either do multiple queries in your CFQUERY tag (if your DB connection settings are setup to allow it), or create and call stored proc. That way you don't incur the network latency betwen the ... read more »