rowantrimmer
New member
- Local time
- Today, 22:18
- Joined
- Apr 16, 2004
- Messages
- 9
Hello,
I have written a simple query that just selects 3 fields from a table. I want to export the query results into an xml file. I have no problem in doing that but I notice that if a field is blank in the table it does not output the XML tag as in <\empty_tag>
Can someone please let me know how I can force the export to create the tag even if the field(s) is empty ?
Also can someone let me know how I can automate a query to run that then exports the xml ?
Many thanks
I have written a simple query that just selects 3 fields from a table. I want to export the query results into an xml file. I have no problem in doing that but I notice that if a field is blank in the table it does not output the XML tag as in <\empty_tag>
Can someone please let me know how I can force the export to create the tag even if the field(s) is empty ?
Also can someone let me know how I can automate a query to run that then exports the xml ?
Many thanks
