If you need or want a UUID i(n say SQL server) just use Newid()
-----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 10 March 2005 12:28 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:198162 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
