When using ZSQLMethods we are seeing on occation a KeyError w/ the key value of a SQL statement. I assume this is related to ZSQLMethod caching, but don't know if it's a bug or simple something we've done wrong. We have a few SQL queries that potentially get hit repeatedly, so I've put a 300 second (5 minute) cache on them in the ZSQLMethod advanced options tab. This has had the desired effect of speeding up page serving when the page is accessed rapidly in succession. However we are now getting these KeyErrors once in a while. I'm wondering if the ZSQLMethod may have been expired out of cache, but somehow left behind some reference to it; or if it might just be a pure timing issue. The page is requested at the precise moment the cache cleaner is doing it's thing (not likely I'm guessing). Has anyone else seen this type of error: Error type: KeyError Error value: ("SELECT DISTINCT... Any ideas where to look for a fix to this, turning off cache for ZSQLMethod is only a quick fix not a solution for us. Perfomance would be too adversly effected by eliminating SQL caching from all our queries. --Thanks. -- ------------------------------- tonyr@ep.newtimes.com Director of Web Technology New Times, Inc. -------------------------------