What dbms?
Doug
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom McNeer
Sent: Friday, November 03, 2006
3:50 PM
To: reactor@doughughes.net
Subject: Re: [Reactor for CF]
Third try for this topic - Reactor creates duplicate fields in objects
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--