Re: XML from mysql tables

[Virginia O'Connor]

To add to what Bill has mentioned, and because I work with the product daily, the XAware product lets you quickly build SQL requests. To give you an idea, a request that looks similar to this:

<xa:request>SELECT
ACCOUNTS.ACCOUNTREPS.REPID,
ACCOUNTS.ACCOUNTREPS.DIVNAME,
ACCOUNTS.ACCOUNTREPS.DIVID,
ACCOUNTS.ACCOUNTREPS.LASTNAME,
ACCOUNTS.ACCOUNTREPS.FIRSTNAME,
ACCOUNTS.ACCOUNTREPS.PHONE,
ACCOUNTS.ACCOUNTREPS.STARTDATE,
ACCOUNTS.ACCOUNTREPS.SALARY,
ACCOUNTS.ACCOUNTREPS.REVIEWDATE
FROM
ACCOUNTS.ACCOUNTREPS
WHERE
((ACCOUNTS.ACCOUNTREPS.DIVID LIKE ?))
</xa:request>

... can be mapped to a template, like this:

<xa:row_template>
<representatives>
<rep DivisionID="%DIVID%" DivisionName="%DIVNAME%">
<name>%FIRSTNAME% %LASTNAME%</name>
<start>%STARTDATE%</start>
<salary>%SALARY%</salary>
<reviewDate>%REVIEWDATE%</reviewDate>
</rep>
</representatives>
</xa:row_template>

... and produce XML like this:

<representatives>
<rep DivisionID="NW2" DivisionName="Northwest 2">
<name>Fred Sanders</name>
<start>1999-09-09</start>
<salary>34000.00</salary>
<reviewDate>2005-04-15</reviewDate>
</rep>
</representatives>
<representatives>
<rep DivisionID="NW2" DivisionName="Northwest 2">
<name>Sally Topper</name>
<start>2003-09-09</start>
<salary>43000.00</salary>
<reviewDate>2000-05-18</reviewDate>
</rep>
</representatives>

Of course, you probably have your own XML schema (or at least an idea of the XML structure you want your data to be plugged into). The XAware Designer will easily map the data from your tables to your XML hierarchy.

Good luck!

Virginia
Technical Writer, XAware, Inc.