XML Import-Export Forum :: XML Recordset problem

I'm trying to use the XML as recordset features.  When I create the server behavior in Dw it asks me basic info including the URL where the XML is located.  From within this dialog I click the Test button and it says "The URL source returned valid XML data". I click OK and the bindings panel shows the new recordset.

When I click on the pluss to try to show the fields I get the error "Duplicate output alias 'element'"

So why is that happening ??  The XML opens fine in web browsers and in any XML editor so I'd have to say it's valid.

I have unchecked the cache item in the bindings panel.

My Dreamweaver version is 8.0.1

The IUSR have read/write permissions on all files and subfolders on the site.

I'm attaching a copy of my XML file.

Regards
Rune

Hello,

This is happening because the XML must have the following structure:

<root>
    <row>
        <fieldname1></fieldname1>
        <fieldname2></fieldname2>
    </row>
    <row>
        <fieldname1></fieldname1>
        <fieldname2></fieldname2>
    </row>
</root>

So the third element must be a fieldname, and so unique within it's parent element. However, in your XML, the fourth field is the fieldname.

Regards,
Razvan RACASANU

What about this file.  The error message is "Incorrect syntax near the keyword 'from'.

Regards
Rune

Hello,

The location element contains further subelements. Also, since the time element is actually a row in the table, is cannot contain multiple location element. Please try with the same xml file but remove those subelements and duplicated location elements so that it only contains this structure:

<pointdata>
    <time>
        <start>2007-01-17T12:00:00Z</start>
        <duration>PT0H</duration>
        <location name="Askvoll" id="1428">
            a location...
        </location>
    </time>
    .....
</pointdata>

Regards,
Razvan RACASANU