Re: [Reactor for CF] RE: [Reactor For CF] computed columns

Thu, 05 Oct 2006 07:27:53 -0700

Similiar to external fields. Which other databases have this feature?

Beth

On 10/5/06, Gareth Cole <[EMAIL PROTECTED] > wrote:

Yes. Ideally it should ignore them in create() and update() methods, but they can still be read by any method that doesn't change data

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Beth Bowden
Sent: 05 October 2006 14:56
To: reactor@doughughes.net
Subject: Re: [Reactor for CF] RE: [Reactor For CF] computed columns

 

Would it make sense for Reactor to ignore computed columns?

On 10/5/06, Gareth Cole <[EMAIL PROTECTED]> wrote:

Thanks Doug. I'll see if I can use a work around for now.

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Doug Hughes
Sent: 04 October 2006 21:11
To: reactor@doughughes.net

Subject: RE: [Reactor for CF] RE: [Reactor For CF] computed columns

 

You can go ahead and log this as a bug, but I doubt this will make it into reactor 1.0.  Besides, you could add a method to your record to calculate the value and you could also create a view to run the calculation for you to use with gateways.

 

Doug

 

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Teddy Payne
Sent: Wednesday, October 04, 2006 3:51 PM
To: reactor@doughughes.net
Subject: Re: [Reactor for CF] RE: [Reactor For CF] computed columns

 

Hmm, I typically leave computed columns for stored procedures or views and not a part of the inherent data set.  It just adds overhead when doing large amounts of transactions. 

I do not remember if there is a way to ignore a column or if modifying the TO not to use the computed column is a good solution or not.

Teddy

On 10/4/06, Gareth Cole <[EMAIL PROTECTED]> wrote:

No. It's not a primary key column.

 

The table is perfectly normal in every regard, except it also has a computed column – this is a column that's value is calculated from the values of other columns. I'm not sure if this is a feature unique to MS SQL 2Kâ€Ĥ

 

You can read the value of a computed column, but if you try to set the value using an insert or update statement, you will get an sql error.

 

I suppose I should update the example below:

 

CREATE TABLE prices(

priceID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,

retail money,

                        sale money,

                        cost_diff AS (retail – sale)

)

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Teddy Payne
Sent: 04 October 2006 18:14
To: reactor@doughughes.net

Subject: Re: [Reactor for CF] RE: [Reactor For CF] computed columns

 

Are you trying to modify a primary key column?

Teddy

On 10/4/06, Gareth Cole <[EMAIL PROTECTED]> wrote:

Hi,

 

I was wondering if anyone could help me with this?

When I try to save a record where the table has a computed column, I get the error: "Column 'xxxxxxxx' cannot be modified because it is a computed column."

 

I'm a bit stuck with this one, as I can't re-write the table this time.

Would it be possible to over-write the save() method in some way?

Ideally, reactor should just ignore a computed column when it generates it's insert and update statements. I'm not sure if it can get this info from the sql server.

 

Any help is appreciated

 

Thanks

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Gareth Cole
Sent: 08 May 2006 14:58
To: reactor@doughughes.net
Subject: [Reactor For CF] computed columns

 

Hi Folks,

 

Apologies if this has been asked before, but does reactor work with computed columns?

 

An example column would be:

CREATE TABLE prices(

            retail money,

            sale money,

            cost_diff AS (retail – sale)

)

 

In the case of cost_diff column, you would want reactor to create a getter method, but not a setter.

 

Thanks,

 

Gareth

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




--
<cf_payne />

Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --




--
<cf_payne />

Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


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

Reply via email to