Re: [Reactor for CF] Third try for this topic - Reactor creates duplicate fields in objects

[Tom McNeer]

Hi Beth,

Here's a start at least: There's nothing unusual about the Reactor config. Here's the object code for one of the tables:
               
        <object name="DEFENDANT_SUPP">
            <field name="DEFENDANT_ROW_ID" alias="defendantRowID" />
            <field name="DEF_SERV_DT_DATE" alias="dateServed" />
            <field name="DEF_RESP_TP_CODE" alias="defendantType" />
            <field name="DEF_SS_NO_TEXT" alias="defendantSSN" />
            <field name="DESC_OCC_MEMO" alias="summary" />
            <field name="COVGENT_ID_NUM" alias="PEMSCoverageID" />
            <field name="PEMSCVG_TYP_CODE" alias="PEMSCoverageType" />
            <hasOne name="DEFENDANT">
                <relate from="defendantRowID" to="defendantRowID" />               
            </hasOne>
        </object>

Here's the table:


CREATE TABLE [dbo].[DEFENDANT_SUPP] (
    [PHYSCAT_CODE]        int NULL,
    [DEF_SS_NO_TEXT]      varchar(11) NULL,
    [DEFENDANT_ROW_ID]    int NULL,
    [D_BRD_CT_CODE]       int NULL,
    [DEF_EXP_CODE]        int NULL,
    [DEF_DEG_CODE]        int NULL,
    [DEF_SERV_DT_DATE]    varchar(8) NULL,
    [DEF_MCIC_IN_CODE]    int NULL,
    [DEF_INS_PMT_AMT]     float NULL,
    [D_APP_LIAB_NUM]      float NULL,
    [DEF_RES_CAS_CODE]    int NULL,
    [DEF_RES_DT_DATE]     varchar(8) NULL,
    [D_RPT_NAT_D_CODE]    int NULL,
    [DEF_AFF_ENT_CODE]    int NULL,
    [NYH_PAN_MD_TEXT]     varchar(55) NULL,
    [NYH_PAN_ATY_TEXT]    varchar(55) NULL,
    [NYH_DISPOS_CODE]     int NULL,
    [NYH_DISP_DT_DATE]    varchar(8) NULL,
    [NYH_HOW_SVD_CODE]    int NULL,
    [NYH_OFF_REC_TEXT]    varchar(55) NULL,
    [NYH_DR_CODE_TEXT]    varchar(5) NULL,
    [NY_JURIS_DF_CODE]    int NULL,
    [NYH_DR_COD_CODE]     int NULL,
    [NYH_REC_OBT_CODE]    int NULL,
    [COV_CODEF_CODE]      int NULL,
    [NYS_EXCESS_CODE]     int NULL,
    [COV_LEVEL_CODE]      int NULL,
    [CVG_LEVEL_CODE]      int NULL,
    [RPT_NAT_DB_DATE]     varchar(8) NULL,
    [COMM_DOCTOR_CODE]    int NULL,
    [NYWDOC_CODE_TEXT]    varchar(5) NULL,
    [DEF_DUVAL_CODE]      int NULL,
    [DEF_DUNIT_CODE]      int NULL,
    [DEF_RESP_TY_CODE]    int NULL,
    [DEF_RESP_TP_CODE]    int NULL,
    [PEMS_DEPT_TEXT]      varchar(50) NULL,
    [DEPT_TEXT]           varchar(50) NULL,
    [ISO_CODE]            int NULL,
    [PEMSCVG_TYP_CODE]    int NULL,
    [PRIMCVGEFDT_DATE]    varchar(8) NULL,
    [PRIMCVGTRDT_DATE]    varchar(8) NULL,
    [RETROSTRDT_DATE]     varchar(8) NULL,
    [RETROENDDT_DATE]     varchar(8) NULL,
    [ISODESC_TEXT]        varchar(100) NULL,
    [INS_LIC_TEXT]        varchar(50) NULL,
    [MCIC_TEXT]           varchar(500) NULL,
    [DEF_DEG_TEXT]        varchar(50) NULL,
    [DEF_MCIC_IN_TEXT]    varchar(500) NULL,
    [PHYSCAT_TEXT]        varchar(500) NULL,
    [CVG_LEVEL_TEXT]      varchar(500) NULL,
    [DEF_DUNIT_TEXT]      varchar(500) NULL,
    [AFF_ENT_TEXT]        varchar(50) NULL,
    [ISO_TEXT]            varchar(50) NULL,
    [EMAIL_TEXT]          varchar(100) NULL,
    [INS_INT_ADD_TEXT]    varchar(50) NULL,
    [INS_MI_TEXT]         varchar(10) NULL,
    [INS_FORMER_TEXT]     varchar(100) NULL,
    [COVGENT_ID_NUM]      float NULL,
    [DESC_OCC_MEMO]       text NULL
    )
GO
CREATE UNIQUE INDEX [DEFENDANT_SUPP_PK]
    ON [dbo].[DEFENDANT_SUPP]([DEFENDANT_ROW_ID])
    WITH FILLFACTOR = 90
GO


When I make the first request for a record from this table, the objects written to my Projects folder repeat the fields some 10 times. So I then get an error noting the duplication of fields.

This table is part of a rather strange database which is part of a licensed third-party application. I've observed the same behavior with the creation of objects for two other tables from this database; but Reactor has created perfectly normal objects for a couple of other tables in the database. That's why I'm figuring it must be something specific to the structure of these tables.

Database server is SQL Server 2000, with all service packs. Thanks for your help, and please let me know if there's any other information I can provide to help the cause.




--
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --