|
Date: 2/4/2008 1:43 pm · Subject: Putting Text around a SQL Report's Fields · Rating: 3
OK, I am attempting to put together the necessary components for implementing Google Site Maps in WebGui. Now that being said, I already have the SQL Report, and I have generated an SQL Report Template, that looks like this: <?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<tmpl_loop rows_loop>
<url>
<loc>/<tmpl_var row.field.url.value></loc><br>
<lastmod>%M/%D/%y",<tmpl_var row.field.revisionDate.value>);</lastmod><br>
</url>
</tmpl_loop>
</urlset> Which formats the data like this:
http://www.SpamZapper.us/isps
1/19/2008
http://www.SpamZapper.us/home
1/17/2008
http://www.SpamZapper.us/configuration/web-manager
2/1/2008
http://www.SpamZapper.us/business
1/17/2008
But the rest of the text fields are missing. How do I include the rest of the template on the output of the SQL Report?
--- (Edited on 2/4/2008 2:43 pm [GMT-0500] by aewhale) ---
--- (Edited on 2/4/2008 2:43 pm [GMT-0500] by aewhale) ---
|
