>- see footer for list info -< Yeah, is GUID not 36 chars, whereas UUID (from CF) is 35?
Or something. Quoting Snake <[EMAIL PROTECTED]>: > >- 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 -< > -- [EMAIL PROTECTED] www.creative-restraint.co.uk www.scottishcfug.com _______________________________________________ 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 -<
