BINGO - Teddy's on with this. The question is can you make this an indexed view so you can do inserts/updates/deletes with it? (If you're using SQL 2005)
I do this all the time with lists of data. Views are awesome in reactor for lists. They may be cool for updates/deletes. I haven't tried that yet. Doug On 2/7/07, Teddy Payne <[EMAIL PROTECTED]> wrote:
Why not create a database view on the columns that you want to use? Reactor should only generate the metadata contained in the view instead of the whole table. Teddy On 2/7/07, Doug Hughes <[EMAIL PROTECTED]> wrote: > > "We already have some problems with keeping generated files > (under /reactor/project/) in source control (TOs) because when updating > reactor.xml you have to remember to change them to match." > > FYI - I don't put these files in source control. They're volatile and > could be considered part of the framework (sorta). Besides, they're > regenerated as needed. For what it's worth, I don't event deploy these > files. I just delete them when they're suspect. > > Doug > > > > On 2/7/07, Tom Chiverton < [EMAIL PROTECTED]> wrote: > > > > On Wednesday 07 Feb 2007, Doug Hughes wrote: > > > Well, I'm not sure how we could implement ignoring fields (and I'm > > not sure > > > it should be done anyhow). > > > > Something in either the XSLT, object.getXML ()/addXmlField() or > > whatever calls > > objectTranslator.generate(), just on first thoughts and a quick > > glance. > > The middle option would be the easiest, just don't add any fields > > marked as > > ignore to the list of ones returned from the parse of the config > > object. > > > > Since adding that isLikeNoCase() I'm a bit more confident adding > > things, this > > might be dangerous :-) > > > > > What if one of the ignored fields was not null? Saving would always > > throw > > > an error. > > > > Then you, the developer, shouldn't marked marked it ignore :-) > > > > > If your hack of mapping them all to the same name works, then that > > might be > > > a cheap fix. > > > > No joy :-/ > > > > > generated code. You might need to do some manual work with it more > > often > > > than not, but then the interface for these objects would be > > consistent > > > across the board. > > > > We already have some problems with keeping generated files > > (under /reactor/project/) in source control (TOs) because when > > updating > > reactor.xml you have to remember to change them to match. > > Adding a cut down version of the files for this table could be worse, > > if a > > column (or more likely alias) is added/changed. > > > > -- > > Tom Chiverton > > Helping to autoschediastically integrate sexy e-markets > > > > **************************************************** > > > > This email is sent for and on behalf of Halliwells LLP. > > > > Halliwells LLP is a limited liability partnership registered in > > England and Wales under registered number OC307980 whose registered office > > address is at St James's Court Brown Street Manchester M2 2JF. A list of > > members is available for inspection at the registered office. Any reference > > to a partner in relation to Halliwells LLP means a member of Halliwells LLP. > > Regulated by the Law Society. > > > > CONFIDENTIALITY > > > > This email is intended only for the use of the addressee named above > > and may be confidential or legally privileged. If you are not the addressee > > you must not read it and must not use any information contained in nor copy > > it nor inform any person other than Halliwells LLP or the addressee of its > > existence or contents. If you have received this email in error please > > delete it and notify Halliwells LLP IT Department on 0870 365 8008. > > > > For more information about Halliwells LLP visit www.halliwells.com. > > > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > Reactor for ColdFusion Mailing List > > [email protected] > > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- > > > > > > > -- > Doug Hughes > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- > -- Teddy R. Payne G-Talk: [EMAIL PROTECTED] Adobe Certified ColdFusion MX 7 Developer Atlanta ColdFusion User Group (ACFUG) Atlanta Flash & Flex User Group (AFFUG) -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- Doug Hughes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
