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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198152 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
