[MOD] Google Sitemap for SQL v8.04

Thanks for this script, it was a big help.  i use it with access and it works great.  If you would like to take an extra step and add the <lastmod> tag to your sitemap for Google, you can insert this script above the <changefreq>:

  <lastmod><%
if(Month(Date)<10 and Day(Date)<10) then
 Response.Write(Year(Date) & "-0" & Month(Date) & "-0" & Day(Date))
else
 if(Month(Date)<10) then
  Response.Write(Year(Date) & "-0" & Month(Date) & "-" & Day(Date))
 else
  if(Day(Date)<10) then
   Response.Write(Year(Date) & "-" & Month(Date) & "-0" & Day(Date))
  else
   Response.Write(Year(Date) & "-" & Month(Date) & "-" & Day(Date))
  end if
 end if
end if
%></lastmod>

enjoy!

Thanks for the code but and it gives me the following errors:

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

---

A string literal was expected, but no opening quote character was found. Error processing resource

 </url> <font face="Arial" size=2>
--------------------------------^

Edited by khaled66 - 31 January 2007 at 1:10pm

superlative süpersin. v8.05 çalışmakta...