Hi, all... I'm thinking about changing from using auto-incrementing integers to CF-generated UUID's for primary keys in my mysql db's.
Any drawbacks in doing that? The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. With a UUID, I can apparently create the UUID in advance and use it for the primary key in the community and also for adding the photos, all on the same page. This is my *first* time using a UUID, so don't leave anything out! Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
