All,

I found the problem (at least in my 2.32 build):

In googleSiteMap.cfm, the QofQ needs to check for nulls:

<cfquery name="qNavSorted" dbtype="query">
        SELECT DISTINCT #sColumns#
        FROM qNavUnsorted 
        WHERE externallink = ''
        OR externallink IS NULL
        ORDER BY #sSort# ASC
</cfquery>  

That fixed my problem, at least.  


-------------------------------------------

Mike Britton
Programmer / Analyst (Contractor)
NTP Information Systems Support
919 541-0642
Email: [EMAIL PROTECTED]
NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC  27709
-----Original Message-----
From: Britton, Michael (NIH/NIEHS) [C] 
Sent: Monday, April 24, 2006 1:59 PM
To: [email protected]
Subject: [farcry-dev] Google sitemap generator


I found the files for the Google sitemap generator here:
 
http://www.e-dynamics.nl/browse/diensten/open-source/farcry-cms-google-s
itemap-generator/index.cfm

I unzipped according to the readme, created the dmcron and when I ran
it, an XML file with no nodes was created.  I ran it without the
optional parameters.

It works fine otherwise.  Anyone have this problem?
 

-------------------------------------------

Mike Britton
Programmer / Analyst (Contractor)
NTP Information Systems Support
919 541-0642
Email: [EMAIL PROTECTED]
NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC  27709 


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---

Reply via email to