My SQL to XML

[Captain_Pugwash]

Hi Guys

 

here is the problem. I use MySQl to query the database and bring back a set of records - works fine

 

What then happens Is that I begin to read through each row recovered.

For each row I read through each attribute and for each attribute I collect the attribute (field) name and use Create element & create_child to create a new xML element. Once the element is created I then add the value of the field to a new element.

 

The idea is that at the end of the whole sequence you have an xml document with an element for each field complete with appropriate value. Now all this works pretty well except one field. No closing tag is created. All other elements have the correct closing tags, except one. the filed name is 'BASE' is this a reserved word or something?

 

I cannot find any reason why this particular field would create a problem. What ever data is retreived this one element always and consistently causes greif. I need to fix it because I need to use a well formed xml object for other things.

 

Thanks in advance

 

CP