Following the tutorial I'm unable to get myDBR to use the specified headers.
For example (Output as SQL):
select 'dbr.export.options', 'xml.declaration', '<?xml version="1.0" encoding="utf-8"?>';
select 'dbr.export.options', 'xml.root_tag', 'dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filmlist.xsd"';
select '9511' as 'description'
union all
select 'International 24\''
union all
select '9510'
union all
select '9557'
union all
select 'Transit';
Exports as (Source):
<report><resultset name="resultset0"><row number="1"><attribute name="description" type="">9511</attribute></row><row number="2"><attribute name="description" type="">International 24'</attribute></row><row number="3"><attribute name="description" type="">9510</attribute></row><row number="4"><attribute name="description" type="">9557</attribute></row><row number="5"><attribute name="description" type="">Transit</attribute></row></resultset></report>
Where am I going wrong?