This also avoids a problem (fixed in a patch at some point....) that CreateUUID() has with the JRE where it can actually slow the machine's clock down a fraction of a second. Adds up over time.
-Joe On Mon, 10 Jan 2005 16:40:23 -0500, Adam Churvis <[EMAIL PROTECTED]> wrote: > Why dont you default that column in your database to NewID()? Now, there is > a difference between ColdFusion's UUID and SQL Server's GUID: > > CREATEUUID() (8-4-4-16: 32 digits) (non-standard format, standard length) > 521490C2-4762-3D9E-FD86E3579D253469 > > SQL SERVER uniqueidentifier (newid()) (8-4-4-4-12: 32 digits) (standard) > F530F547-ED3B-4319-ADAC-E341F73AD55C > > But you can handle the difference by inserting a hyphen at position 23 in > ColdFusion, if for some reason you need to supply a GUID from ColdFusion to > SQL Server. > > Respectfully, > > Adam Phillip Churvis > Member of Team Macromedia > http://www.ProductivityEnhancement.com > > Download Plum and other cool development tools, > and get advanced intensive Master-level training: > > * C# & ASP.NET for ColdFusion Developers > * ColdFusion MX Master Class > * Advanced Development with CFMX and SQL Server 2000 > > ----- Original Message ----- > From: "Marwan Saidi" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, January 10, 2005 4:15 PM > Subject: [plum] Inserting a UUID > > > Is there a way to have the system insert a UUID as a primary key value > using > > the Plum IDE? > > > > > > > > Marwan Saidi > > > > American Eagle Information Systems > > > > 321.779.2577 - p > > > > 321.779.2576 - f > > > > > > > > > > > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
