Re: saving sql data in xml formatted file

[kcott]

The answer rather depends on what XML application you're intending to use.

The process is not particularly dissimilar to what you already have.

You may need something like:

print OUT '<page>';
print OUT '<title>', $objRecordSet->Fields("Titles")->value, '</title>
+';
...
print OUT '<view>', $objRecordSet->Fields("Views")->value, '</view>';
print OUT '</page>';

or perhaps:

print OUT '<page ';
print OUT 'title="', $objRecordSet->Fields("Titles")->value, '" ';
...
print OUT 'view="', $objRecordSet->Fields("Views")->value, '" ';
print OUT '/>';

All of that will probably need to be wrapped in a top-level element. Some header information may be required.