>- see footer for list info -< It seems a UUID is a different format to a GUID So I resorted to a regular identity field for my PK and having the GUID as a separate field.
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene Brown Sent: 22 November 2006 15:05 To: Coldfusion Development Subject: RE: [CF-Dev] uniqueIdentifier datatype >- see footer for list info -< Russ, Why not use the Scope_Identity() Method, I use this in my SP's --- SELECT @id = [id], -- integer @uid = uid -- uniqueidentifier FROM dbo.TableName WHERE [id] = Scope_Identity() --- Cheers Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: Wednesday, November 22, 2006 2:53 PM To: 'Coldfusion Development' Subject: [CF-Dev] uniqueIdentifier datatype >- see footer for list info -< I am trying to use the UniqueIdentifier data type in SQL Server 200 to generate a UUID for each record. But I can't seem to insert it. Using <cfqueryparam cfsqltype="cf_sql_idstamp" value="#ticketID#"> Where ticket ID = CreateUUID() Results in [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting from a character string to uniqueidentifier. I would use the SQL built in function NEWID() to do it on the database, but then I can't easily select the last inserted record to get my new ID. -- Russ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
