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 **********************************************************************
