Re: [Reactor for CF] regenerating dictionary xml files
thanks for a quick answer.With a little investigation, it appears that messages for new fields are added but old ones aren't removed. I guess it's hard to figure which are custom and which were automatically generated. On 7/24/06, Doug Hughes [EMAIL PROTECTED] wrote: This is a bug. I think it might even be in trac. It needs to be fixed. These should update automagically. Somehow or other! Maybe in 2.0 I'll make these CFCs with static strings in them! (duh! Slaps self) That way to change a message you just override the property or something. Doug From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Beth Bowden Sent: Monday, July 24, 2006 12:52 PM To: reactor@doughughes.net Subject: [Reactor for CF] regenerating dictionary xml files When I add or change a column into a table, I typically delete the corresponding files in reactor/project/... and have reactor regenerate the files. I've run into a stumbling block with dictionaries. All dictionary xml files seem to be located in a custom directory. I have some custom messages so I don't want to just delete them. Is there any way I can update a dictionary while keeping my customizations? TIA. Beth -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] DAO generation and Oracle 10
Van,In your categoryMetadata.cfc, is there a line similiar to: cfset variables.metadata.fields[1][primaryKey] = true /?Thanks, Beth On 7/25/06, Van Daele Wouter (DBB) [EMAIL PROTECTED] wrote: (Can't seem to get logged in to the Reactor Trac site, so I'm logging it here...) Doug, all, This morning I downloaded revision 330 of Reactor, cleared the project directory and restarted my app. Unfortunately, I'm still getting badly formed DAO's for all my tables with a (single) primary key. Create and Read are OK; Save, Update and Delete are flawed... From what I had to do to get my app running, I'ld say that the primary keys aren't detected by Reactor (cf. Trac ticket #41 http://trac.reactorframework.com/reactor/trac.cgi/ticket/41 ). Example: here's the Save function as currently generated: cffunction name=save access=public hint=I create or update a CATEGORY record. output=false returntype=void cfargument name=to hint=I am the transfer object for CATEGORY required=yes type=reactor.project.qtau.To.CATEGORYTo / cfset create(arguments.to) / /cffunction There's no way this code can decide between create and update... Similarly, the generated Update and Delete methods end with: ... WHERE /cfquery /cffunction No comments needed, I suppose. This problem is blocking my progress with an app that has to be finished soon; in the current state of affairs I'll have to code my DAO's and Gateways by hand - without Reactor... no fun W. -- Dexia Bank disclaimer : http://www.dexia.be/maildisclaimer.htm -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing List reactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] DAO generation and Oracle 10
Wouter,That's it exactly.BethOn 7/25/06, Van Daele Wouter (DBB) [EMAIL PROTECTED] wrote: Beth, Nope - all linesfor the primaryKey attribute say false. And yet I have a constraint of type UNIQUE on the CATEGORYID column... I suppose that type should be PRIMARY, and not UNIQUE ? Wouter From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Beth BowdenSent: dinsdag 25 juli 2006 15:24To: reactor@doughughes.netSubject: Re: [Reactor for CF] DAO generation and Oracle 10 Van,In your categoryMetadata.cfc, is there a line similiar to: cfset variables.metadata.fields[1][primaryKey] = true /?Thanks, Beth On 7/25/06, Van Daele Wouter (DBB) [EMAIL PROTECTED] wrote: (Can't seem to get logged in to the Reactor Trac site, so I'm logging it here...) Doug, all, This morning I downloaded revision 330 of Reactor, cleared the project directory and restarted my app. Unfortunately, I'm still getting badly formed DAO's for all my tables with a (single) primary key. Create and Read are OK; Save, Update and Delete are flawed... From what I had to do to get my app running, I'ld say that the primary keys aren't detected by Reactor (cf. Trac ticket #41 http://trac.reactorframework.com/reactor/trac.cgi/ticket/41 ). Example: here's the Save function as currently generated: cffunction name=save access=public hint=I create or update a CATEGORY record. output=false returntype=void cfargument name=to hint=I am the transfer object for CATEGORY required=yes type=reactor.project.qtau.To.CATEGORYTo / cfset create(arguments.to) / /cffunction There's no way this code can decide between create and update... Similarly, the generated Update and Delete methods end with: ... WHERE /cfquery /cffunction No comments needed, I suppose. This problem is blocking my progress with an app that has to be finished soon; in the current state of affairs I'll have to code my DAO's and Gateways by hand - without Reactor... no fun W. --Dexia Bank disclaimer :http://www.dexia.be/maildisclaimer.htm-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - Dexia Bank disclaimer : http://www.dexia.be/maildisclaimer.htm - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing List reactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] DAO generation and Oracle 10
You are safe. The latest revision incorporates both changes.On 7/25/06, Van Daele Wouter (DBB) [EMAIL PROTECTED] wrote: I confess that I haven't looked at any specific patches - having just returned from a two-week holiday I downloaded revision 330 and hoped everything would work. Should I look further into this or am I reasonably safe now? Wouter From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]Sent: dinsdag 25 juli 2006 17:00To: reactor@doughughes.net Subject: RE: [Reactor for CF] DAO generation and Oracle 10 Van, Did you look at the solutions for Ticket #41 that Beth and I submitted(5 minutes apart, she beat me, but just by a hair)? For me to get that to work I had to change the query qFields in data\oracle\objectDao.cfc: CASE WHEN primaryConstraints.column_name IS NULL THEN 'false' ELSE 'true' END as primaryKey, And I also had to change this line in the loop: cfset Field.nullable = iif(qFields.nullable eq Y, DE(true), DE(false)) / Maybe that will help? -Nate From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Beth BowdenSent: Tuesday, July 25, 2006 6:24 AMTo: reactor@doughughes.netSubject: Re: [Reactor for CF] DAO generation and Oracle 10 Van,In your categoryMetadata.cfc, is there a line similiar to: cfset variables.metadata.fields[1][primaryKey] = true /?Thanks, Beth On 7/25/06, Van Daele Wouter (DBB) [EMAIL PROTECTED] wrote: (Can't seem to get logged in to the Reactor Trac site, so I'm logging it here...) Doug, all, This morning I downloaded revision 330 of Reactor, cleared the project directory and restarted my app. Unfortunately, I'm still getting badly formed DAO's for all my tables with a (single) primary key. Create and Read are OK; Save, Update and Delete are flawed... From what I had to do to get my app running, I'ld say that the primary keys aren't detected by Reactor (cf. Trac ticket #41 http://trac.reactorframework.com/reactor/trac.cgi/ticket/41 ). Example: here's the Save function as currently generated: cffunction name=save access=public hint=I create or update a CATEGORY record. output=false returntype=void cfargument name=to hint=I am the transfer object for CATEGORY required=yes type=reactor.project.qtau.To.CATEGORYTo / cfset create( arguments.to) / /cffunction There's no way this code can decide between create and update... Similarly, the generated Update and Delete methods end with: ... WHERE /cfquery /cffunction No comments needed, I suppose. This problem is blocking my progress with an app that has to be finished soon; in the current state of affairs I'll have to code my DAO's and Gateways by hand - without Reactor... no fun W. --Dexia Bank disclaimer :http://www.dexia.be/maildisclaimer.htm-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Dexia Bank disclaimer : http://www.dexia.be/maildisclaimer.htm -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing List reactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] Schemas - MS SQL 2005
We normally associate a user with a particular schema. So if we want a different schema, we set the username/password to the DSN appropriately. If I understand right, this won't work for you because you need to across more than one schema. Is that correct? Thanks, BethOn 24 Aug 2006 01:21:19 -, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:To second Matt's email, we have implemented schemas in MS SQL 2005. So we have tables like Core.User and ProductX.Products. Is this supported in Reactor?I'm not sure we can simply put:object name=Core.User alias=User/because that throws errors? Anyone using Schemas in MS SQL 2005? Isee a similar thread on Oracle Schemas as well with no resolution attached.-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[Reactor for CF] adding schema names
I've heard two approaches to adding schema names for tables in the reactor config files. The first is to add an owner which would look like: object name=mytable owner=tigger / The second is to allow fully qualified table names which would look like: object name=tigger.mytable / I tend towards a variation of the first were the schema name can be complicated as needed: object name=mytable schema=tigger.eyore.bear / What are your thoughts? Total indifference, one of these or something new?Thanks, Beth -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[Reactor for CF] reactor change that may impact your code
Folks,To fix the problems that cblackwell pointed out in http://trac.reactorframework.com/reactor/ticket/76, the copy, isequal and configure methods were renamed to _copy, _isequal, and _configure in the \reactor\base\*.cfc files. If your code calls any of these methods manually, please change the calls accordingly. Any plug-ins that extend reactor.base.abstractobject may also need to be changed. This applies to any cfcs that extend files in \reactor\base\.Beth -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] oracle is now handles case-sensitivity object names
Oracle Users, Reactor now matches your objects to the actual tables in Oracle regardless of case. For example, Reactor would match this: object name=SubscriptionTable/ to the SUBSCRIPTIONTABLE f a table named SubscriptionTable doesn't exist. You will need to delete the files under your reactor/project folder. If you run into any problems, let me know.Beth -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion 6.1 (Windows)
Joshua,It doesn't look like we were able to check the fix out in cf6.1. Here's the code in iterator.cfc: cfif ListFirst(Server.ColdFusion.ProductVersion) GTE 7line 463cfset QueryAddColumn( variables.query, reactorRowDeleted, Bit, deletedArray) / cfelse!--- hopefully this works in MX 6.1 ---line 465 cfset QueryAddColumn( variables.query, reactorRowDeleted, deletedArray) / /cfifYour code should be executing line 465 but errors on line 463. Can you tell me the value of Server.ColdFusion.ProductVersion ?Thanks, BethOn 9/22/06, Joshua Scott [EMAIL PROTECTED] wrote: Actually,It looks like this was a known bug that was fixed and must be broken again:http://trac.reactorframework.com/reactor/trac.cgi/changeset/283 - JSJoshua ScottResonant Media Technologies, LLC.http://www.resonantmedia.com | http://blog.resonantmedia.comIt is impossible to get out of a problem by using the same type of thinkingthat it took to get into the problem. -- Albert Einstein-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] OnBehalf Of Joshua ScottSent: Friday, September 22, 2006 8:45 AM To: reactor@doughughes.netSubject: RE: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion6.1 (Windows)A couple of things.1. The DSN verifies in CF Administrator with no problem. So I can not imagine that it is a DSN issue, also reactor initially had some securityissues with the database which I resolved which makes me know that at leastit sees the db.2. I can point the browser to the XML file and it works like a champ. Again the XML file is fine because the same XML file runs the site on the CF 7server.What other ideas does anyone have? I willing to try anything.Thanks,Josh Joshua ScottResonant Media Technologies, LLC.http://www.resonantmedia.com | http://blog.resonantmedia.comIt is impossible to get out of a problem by using the same type of thinking that it took to get into the problem. -- Albert Einstein-Original Message-From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] OnBehalf Of Denny ValliantSent: Friday, September 22, 2006 1:57 AMTo: reactor@doughughes.netSubject: Re: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion 6.1 (Windows)On 9/21/06, Joshua Scott [EMAIL PROTECTED] wrote:... My gut tells me that somehow reactor is not reading its xml doc or something but I am not getting any errors that would indicate that. Not having tried Reactor with 6.1, all I can suggest is: are you sure theDSN is good in 6.1? And: Are you getting any errors at all?What other debugging steps have you taken?Tried reading the xml file some other way, or other avenues of marking things off the list?More info.Need more info.=]|D-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archivesat: 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 Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Re: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion 6.1 (Windows)
Joshua,That's puzzling. Perhaps, a leading space? Can you change line 462 to: cfif ListFirst( trim(Server.ColdFusion.ProductVersion) ) GTE 7Thanks,BethOn 9/22/06, Joshua Scott [EMAIL PROTECTED] wrote: That value returns: 6,1,0,hf45343_611 - JS Joshua ScottResonant Media Technologies, LLC.http://www.resonantmedia.com | http://blog.resonantmedia.com It is impossible to get out of a problem by using the same type of thinking that it took to get into the problem. -- Albert Einstein From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Beth BowdenSent: Friday, September 22, 2006 10:06 AMTo: reactor@doughughes.netSubject: Re: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion 6.1 (Windows) Joshua,It doesn't look like we were able to check the fix out in cf6.1. Here's the code in iterator.cfc: cfif ListFirst(Server.ColdFusion.ProductVersion) GTE 7line 463 cfset QueryAddColumn( variables.query, reactorRowDeleted, Bit, deletedArray) / cfelse !--- hopefully this works in MX 6.1 ---line 465 cfset QueryAddColumn( variables.query, reactorRowDeleted, deletedArray) / /cfifYour code should be executing line 465 but errors on line 463. Can you tell me the value of Server.ColdFusion.ProductVersion ?Thanks, Beth On 9/22/06, Joshua Scott [EMAIL PROTECTED] wrote: Actually,It looks like this was a known bug that was fixed and must be broken again:http://trac.reactorframework.com/reactor/trac.cgi/changeset/283 - JSJoshua ScottResonant Media Technologies, LLC.http://www.resonantmedia.com | http://blog.resonantmedia.comIt is impossible to get out of a problem by using the same type of thinkingthat it took to get into the problem. -- Albert Einstein-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] OnBehalf Of Joshua ScottSent: Friday, September 22, 2006 8:45 AM To: reactor@doughughes.netSubject: RE: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion6.1 (Windows)A couple of things.1. The DSN verifies in CF Administrator with no problem. So I can not imagine that it is a DSN issue, also reactor initially had some securityissues with the database which I resolved which makes me know that at leastit sees the db.2. I can point the browser to the XML file and it works like a champ. Again the XML file is fine because the same XML file runs the site on the CF 7server.What other ideas does anyone have? I willing to try anything.Thanks,Josh Joshua ScottResonant Media Technologies, LLC.http://www.resonantmedia.com | http://blog.resonantmedia.comIt is impossible to get out of a problem by using the same type of thinking that it took to get into the problem. -- Albert Einstein-Original Message-From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] OnBehalf Of Denny ValliantSent: Friday, September 22, 2006 1:57 AMTo: reactor@doughughes.netSubject: Re: [Reactor for CF] Perplexing Bug - Reactor / MG:U on ColdFusion 6.1 (Windows)On 9/21/06, Joshua Scott [EMAIL PROTECTED] wrote:... My gut tells me that somehow reactor is not reading its xml doc or something but I am not getting any errors that would indicate that. Not having tried Reactor with 6.1, all I can suggest is: are you sure theDSN is good in 6.1? And: Are you getting any errors at all?What other debugging steps have you taken?Tried reading the xml file some other way, or other avenues of marking things off the list?More info.Need more info.=]|D-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archivesat: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archivesat: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing List
Re: [Reactor for CF] RE: [Reactor For CF] computed columns
Similiar to external fields. Which other databases have this feature?BethOn 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 '' 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
