The other benefit of createUUID() is that you can later split / combine records from different tables if you ever need to, such as pulling production records down to review in development ... no integer clashes when you've got fully unique values across the tables and datasources.
---------------------------------------- From: "Justin Scott" <jscott-li...@gravityfree.com> Sent: Thursday, June 04, 2009 12:42 PM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: RE: Generating appopriate transaction IDs > getTickcount() or createUuid() You'll run into dupes pretty quickly by using getTickCount() since it resets back to 1 every time the server restarts. Not recommended. CreateUUID() would work much better if you don't want integer only IDs. -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4