>- see footer for list info -< Ah, that's the one! I believe it's a "feature" of CF. Whichever engineer dealt with createuuid() messed up the position of one of the dashes.
I normally just use cf_sql_char(35) for my uuids so I've never actually come across the problem myself. Quoting Snake <[EMAIL PROTECTED]>: > >- see footer for list info -< > They both appear to be 32, but the dashes are in a different place > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Andy Allan > Sent: 22 November 2006 16:49 > To: Coldfusion Development > Subject: RE: [CF-Dev] uniqueIdentifier datatype > > >- 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 > >-< > > > _______________________________________________ > > 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 -<
