Re: [Reactor for CF] Using GUID/UUID for Primary Key

[Brad Haas]

I did some testing and I don't seem to be having a problem (yet) with using primary keys that are not auto assigned and/or are not guids.  I've tried both saves and updates on a record and everything seems to be working.  Of course I have to set the PK field value when adding a record, but other than that I don't notice a difference. Brad On Aug 8, 2006, at 5:01 PM, João Fernandes wrote: Brad, I never tried anything else other than auto assigned or guid PKs but when Wayne mentioned to add <cfset this.myPk = createUUID()> into your TO's, it's a way to override reactor's default behavior, it can be applied not only to PK but to any column.  João Fernandes On 8/8/06, Brad Haas <[EMAIL PROTECTED]> wrote: I may be reading this thread wrong, but are you guys saying that you cannot create your own primary key to use in MS SQL Server?  I've got a few tables in a db that use a SKU as a primary key and it is not auto assigned by SQL nor is it a guid. Is this going to be a problem for me or am I just reading this out of context? Thanks, Brad On Aug 8, 2006, at 9:59 AM, Wayne Graham wrote: > It's documented (though it took me a while to find it) at http:// > livedocs.reactorframework.com/Save_Changes_to_a_Record.htm > > Basically, throw this code into the TO: > > <cfset this.primaryKey = createUUID() /> > > HTH, > Wayne > > Mark Drew wrote: >> I am also trying to do this, but on mysql (there is a reason I >> need CF >> uuid's .. honest!) >> Can I change the TO to handle this? >> Sorry for the "n00b" question... considering I have been singing and >> lecturing Reactor's prases!) >> MD >> On 8/8/06, Marc Funaro <[EMAIL PROTECTED]> wrote: >>> >>>    >   -----Original Message----- >>>    >   From: [EMAIL PROTECTED] >>>    >   [mailto:[EMAIL PROTECTED]] On Behalf Of Doug Hughes >>>    >   Sent: Tuesday, August 08, 2006 8:42 AM >>>    >   To: reactor@reactorframework.com >>>    >   Subject: RE: [Reactor for CF] Using GUID/UUID for Primary Key >>>    > >>>    >   Marc - Just use MSSQL's guid column type.  Reactor >>>    >   automatically translates between CF and MSSQSL's >>>    >   guid/uuid formats. >>>    > >>>    >   Doug >>> >>> Truly Truly Awesome.  I can't tell you how cool this all is. >>> >>> >>> >>> >>> >>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>> -- -- -- -- -- >>> Reactor for ColdFusion Mailing List >>> reactor@doughughes.net >>> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ >>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- >>> -- -- -- -- -- >>> >>> > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- > Reactor for ColdFusion Mailing List > reactor@doughughes.net > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --