MS Access XML with CF....

[ghoukster]

A user has an access database that they want to export an xml file out of, and
through cf, upload the file and have the contents inserted into the sql server
db. No problem, I know how to do this. The problem is that the xml elements are
not consistent. For example, if the contact field is null in one of the
records, then the xml file doesn't generate <Contact></Contact>. It drops it
altogether. So, how can this be cared for in CF? Code such as: <cfoutput>
<tr> <td>#mydoc.dataroot.tblMfgReps_Web.Region[1].XmlText#</td>
<td>#mydoc.dataroot.tblMfgReps_Web.Company[1].XmlText#</td>
<td>#mydoc.dataroot.tblMfgReps_Web.Contact[1].XmlText#</td> </tr>
</cfoutput> will not work. It throws this error: The index of a child element
is out of range. There are only '1' children under this node. Therefore
index '2' is out of the allowed range [1-1]. Text Any ideas? Thanks, Gary

[Brian Hogue]

Gary -

I have only read the CF 6 documentation on XML data. I thought there is a
tag or function to read XML data. Is that row's Contact information NULL? If
yes, then at least you have a placeholder for your Contact column in that
row. Otherwise, it sounds like your code needs to check for the existence of
each column in each row. Maybe someone has a better solution.

-brian

"ghoukster" <gary@garyhouk.com> wrote in message
news:d1fks6$6k9$1@forums.macromedia.com...

> A user has an access database that they want to export an xml file out of,

and

> through cf, upload the file and have the contents inserted into the sql

server

> db. No problem, I know how to do this. The problem is that the xml

elements are

> not consistent. For example, if the contact field is null in one of the
> records, then the xml file doesn't generate <Contact></Contact>. It drops

it

> altogether. So, how can this be cared for in CF? Code such as: <cfoutput>
> <tr> <td>#mydoc.dataroot.tblMfgReps_Web.Region[1].XmlText#</td>
> <td>#mydoc.dataroot.tblMfgReps_Web.Company[1].XmlText#</td>
> <td>#mydoc.dataroot.tblMfgReps_Web.Contact[1].XmlText#</td> </tr>
> </cfoutput> will not work. It throws this error: The index of a child

element

> is out of range. There are only '1' children under this node. Therefore
> index '2' is out of the allowed range [1-1]. Text Any ideas? Thanks,

Gary

>