Creating XML from ADO recordset object.

[Satish]

I want to know any easy and short method to generate the XML from the recordset
or vice versa.

[Craig Clearman]

Satish,

>I want to know any easy and short method to generate the XML from the recordset

..Save sFileName, adPersistXML

Ciao, Craig

[Jim Anderson]

If you are using 2.5, you can also save it to a stream in memory without writing
it to a file (if you are looking to manipulate the XML in code or are looking
to pass it to another object).

Craig Clearman <chclear@nospam.please> wrote:
>Satish,
>
>>I want to know any easy and short method to generate the XML from the recordset
>
>..Save sFileName, adPersistXML
>
>Ciao, Craig
>

[Oleg]

"Jim Anderson" <anderson_jim@excite.com> wrote:
>
>If you are using 2.5, you can also save it to a stream in memory without
writing
>it to a file (if you are looking to manipulate the XML in code or are looking
>to pass it to another object).
>
I'd gratly appreciate if you give me a clue how to "save it to a stream in
memory without writing it to a file".
I'm creating XML using DHTML and I'd like to save XML as a form field and
pass it for processing.

[Craig Clearman]

Oleg,

>I'd gratly appreciate if you give me a clue how to "save it to a stream in
>memory without writing it to a file".

The .Save method in ADO 2.5 will now take either a file name or a
stream object.

So instead of:

RecSet.Save "C:\Whatever.xml", adPersistXML

You can use

RecSet.Save objStream, adPersistXML

Now it is saved in a stream of information (essentially as string).

Ciao, Craig