Recordset to XML
Dreamweaver Server Behavior

Structure of the produced XML

The XML produced by the Server Behavior will have the following structure:

<recordset total="1000">
    <record>
        <field1>some value</field1>
        <field2>some value</field2>
    </record>
    <record>
        <field1>some value</field1>
        <field2>some value</field2>
    </record>
</recordset>

<recordset> is the root node of the generated XML (attribute "total" indicates the total number of records in the Recordset).
It contains <record> nodes which represent the records.
Each <record> node contains record's field nodes.
The name of each field node will be the same as the name of the corresponding Recordset field while the node text will be the value of that field.
For example, if your Recordset has a field USER_ID and one of the values is "10" that value will be represented in the XML by a field node structured as follows:

<USER_ID>10</USER_ID>

If the recordset is empty (contains no records) output will contain only root element - <recordset>:
<recordset total="0">
</recordset>

Dreamweaver version Compatibility

• Dreamweaver 8
• Dreamweaver CS3
• Dreamweaver CS4
• Dreamweaver CS5 and CS5.5

Demo