now that's refering to the logic (CF, ASP, PHP, whatever) creating the UUID, yes?
Yes.
so taking Spike's point a bit further, what could go wrong if there are multiple logic tiers (not just CF) all creating their own UUID's for inserts? this would be madness , surely, and you'd leave it up to the db to generate the UUID's?
How many apps have you built with multiple tiers in different languages inserting into the same DB? How hard would it be to write a function for each development platform to generate UUIDs by the same algorithm?
Again this discussion really revolves around the appropriate application of one approach or other based on the specific application you're writing. Not all applications would suit UUID PK's -- but people would be foolish to simply discount them altogether as they represent a powerful mechanism to solve all manner of application problems.
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
