[Zope-DB] zsql method w/ more than one field failing?

Christopher Heschong chris@screwdriver.net
Tue, 27 May 2003 18:08:54 -0400


OK, I have a very simple sql method.  It has 2 arguments (inet, client_hostname).  Here's the text of the 
method:

select * from lease
  <dtml-sqlgroup where>
    <dtml-sqltest inet type=nb op=eq optional>
  <dtml-and>
    <dtml-sqltest client_hostname type=nb op=eq optional>
  </dtml-sqlgroup>

When I click on "test" and put in the value 'a' for inet and the value 'b' for client_hostname, it returns this 
sql query:

select * from lease
  where
client_hostname = 'b'

When I add more fields, it only uses the last field in the SQL query.  Ack!

I'm running Zope 2.6.1 and ZMySQLDA 2.0.8

What could I be doing wrong?

-- 
/chris/