Re: [Zope] Form variables with same name as folder names

1) the ZSQL manual, http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.4.html, says that the first lookup should be variables in HTTP_REQUEST. So why is FOO referring to my folder FOO?

Its true it does and I found the exact problem. A chance to lob this bug into the collector.

2) is there some way I could have referred to the variable FOO in my Z SQL method without resorting to renaming the variable in my form?

Rename your folder :)