>- see footer for list info -< Yea I was gonna do that, but then I decided it was probably more efficient to have the primary key and thus all foreign key relationships on an INT field anyway rather than a GUID field.
Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Sent: 22 November 2006 22:05 To: Coldfusion Development Subject: Re: [CF-Dev] uniqueIdentifier datatype >- see footer for list info -< That's a sillyism of CF. How much effort would it be for them to fix or add a proper createGUID() function? Anyway, here's how to fix it: <CFSET newGUID=insert("-", CreateUUID(), 23)> The above will create a new genuine GUID, compatible with MS SQL for example. Gary. On 11/22/06, Andy Allan <[EMAIL PROTECTED]> wrote: > > >- 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 >-< _______________________________________________ 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 -<
