in reply to saving sql data in xml formatted file
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.
-- Ken
|
|---|