I would typically favor the IETF pattern as that seems closer to 'correct'. It's trivial to use one of those UDFs to match that from other sources.
This would also mean that in one database there would be nothing extra required to using newID() as a default, and then there would only remain Oracle to futz with for a pattern. Of course, all this aside, if your database field is 36 characters in length, then it really doesn't matter where they hyphens are because they aren't part of what makes these IDs unique. - Calvin -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 7:28 AM To: CF-Talk Subject: RE: UUID creation outside CF Those UDFs do that same thing I was thinking of - modifying a UUID from one system by moving hyphens to make them match the other's format. If no-one has had problems with this approach then that's what I'll do (but at the DB end instead). -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 March 2005 8:17 To: CF-Talk Subject: RE: UUID creation outside CF CF and SQL Server are known to use differing UUID logic. This is why you cannot rely on CF to create one for SQL! Any one of these will help http://www.cflib.org/udf.cfm?ID=54 http://www.cflib.org/udf.cfm?ID=288 http://www.cflib.org/udf.cfm?ID=512 -----Original Message----- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 10 March 2005 11:59 To: CF-Talk Subject: RE: UUID creation outside CF First, who has the correct number of hyphens? SQL Server: F1D8EEEB-8F16-41F1-9E73-1E27C65AC14C IETF Draft Example: f81d4fae-7dec-11d0-a765-00a0c91e6bf6 (http://www.ietf.org/internet-drafts/draft-mealling-uuid-urn-05.txt) CFMX 7: 8C5302DB-C291-F05B-FFC9200478D6DC15 Comments? - Calvin -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 5:07 AM To: CF-Talk Subject: RE: UUID creation outside CF I guess I could edit the result from SYS_GUID() (oracle) or NewID() (MS SQL) to add the hyphens in the right place and just assume that it will still be unique with regards to a CF UUID. Anyone have input on collisions between these algorithms? -----Original Message----- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 March 2005 5:50 To: CF-Talk Subject: RE: UUID creation outside CF What RDBMS are you using? Normally database servers are featured with functionality for the creation of an UUID. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ----- Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl ------------------------------------------------------------------------ ------------------------------------------------------------------------ ----- -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: donderdag 10 maart 2005 10:41 To: CF-Talk Subject: UUID creation outside CF Is the CF algorithm for UUID creation public knowledge? I'd like to write a stored proc for my DB to create these rather than having to rely on CF to do it, but I want to use the same algorithm to reduce any chance of a collision. James Holmes Divisional Web Interface Development Coordinator Engineering, Science and Computing x4864 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198163 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
