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: [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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --



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

Reply via email to