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: [email protected]
   >   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
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --




-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to