Trying :

        select * from mytable <sqltest mylist multiple type=int column=id>

did not work, it generates a ProgrammingError

   - Module Shared.DC.ZRDB.DA, line 374, in __call__
   - Module Products.ZMySQLDA.db, line 273, in query

ProgrammingError: (1064, "You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax to
use near '<sqltest mylist multiple type=int column=id> LIMIT 1000'")

My problem was that I tried to test my Z SQL method through the ZMI, testing
with a python script worked fine with the following Z SQL method :
FROM MyTable
<dtml-sqlgroup where>
  <dtml-sqltest mylist column=id type=int multiple>
</dtml-sqlgroup> I also modified the "mylist" parameter declaration to
specify that it is a list of integers which is set to none if no parameter
is passed.

Thanks for your reply
Zope maillist  -
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to