Re: Create xml with VB

[wxdqz]

"Rohit Wason" <[email protected]> wrote:>>"dumm" <[email protected]> wrote:>>>>Hi,>>Need some hints on creating xml file in VB 6.>>>>Examples? Hints?>XML can be created by any **** source - SQL, VB, ASP, C, C++ any thing you>can imagine. XML is a "general" form text written in some hierarchical manner>eg:>><Persons>> <Person>> <Name>Rohit</Name>> <Age>23</Age>> </Person>> <Person>> <Name>Shubo</Name>> <Age>123</Age>> </Person>> <Person>> <Name>dumm</Name>> <Age>??</Age>> </Person>></Persons>>>The data above represents a few records of persons.>This can be read from any source (SQL/Oracle or whatever) and written using>VB/VC/ASP/ or whatever.>>In VB for instance, we can write:>Print #1, "<Persons>" + vbCRLF & _>" <Person>" + vbCRLF & _>" <Name>Rohit</Name>" + vbCRLF & _>" <Age>23</Age>" + vbCRLF & _>" </Person>" + vbCRLF & _>" <Person>" + vbCRLF & _>" <Name>Shubo</Name>" + vbCRLF & _>" <Age>123</Age>" + vbCRLF & _>" </Person>" + vbCRLF & _>" <Person>" + vbCRLF & _>" <Name>dumm</Name>" + vbCRLF & _>" <Age>??</Age>" + vbCRLF & _>" </Person>" + vbCRLF & _>"</Persons>">>Okay?--------------------I know this way man! But the problem is that your code is not general. Whatif we are taking data from a database and we don't really know the fieldnames(we are using field names as elements)?Another thing is that your data may contain some special characters ("/","<", ">", "&", etc.) and in this case your output XML may not be well-formed!!!I am writing VB code to export a finacial report in XML, please give me youradvice.Thanks~Cuong