[Zope] dtml-sqltest

[Montagne, Michael]

The following string in a ZSQL method will not include any where clause.
What is wrong?  The MktSectorID field occurs in both tables so I need to
specify it with the dot notation.  Could that be it?  If I remove the
optional, I get the same result.  


SELECT tblProjData.projnumb, tblProjData.projname,
tblProjPhase.ProjIsActive, tblProjMktSector.projtype,
tblProjData.MktSectorID FROM (tblProjData INNER JOIN tblProjMktSector ON
tblProjData.MktSectorId = tblProjMktSector.MktSectorID) INNER JOIN
tblProjPhase ON tblProjData.ProjPhaseID = tblProjPhase.StatusID
<dtml-sqlgroup where>
<dtml-sqltest tblProjData.MktSectorID type="int" op="eq" optional>
</dtml-sqlgroup>
ORDER BY tblProjData.projnumb;