Re: ZSQL + MySQL + sqltest + list

Matthew Fairclough <[email protected]>
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
>What is the exact error? Please show us the complete traceback from the
>error.log and the complete ZSQL-Method, please.

Many thanks.  Full query is:

select * from category  where
<dtml-sqltest clientAssocList column="clientID" type=int multiple>

Arguments in ZSQL method are:
clientID=0 qID=0 clientAssocList=0 qList=0

Entry in test page is:
ClientAssocList: 4,5,6
(all others at default)

Result is:
--
Error, exceptions.ValueError: Invalid integer value for clientAssocList
--------------------------------------------------------------------------------
SQL used:

Could not render the query template!
--

Does the same thing regardless of input if more than one integer.  I need
ClientAssocList to be a list of integers.  I don't think it is an SQL or MySQL
issue- but an issue with the ZSQL Method.

Assistance much appreciated.

Regards,

--
Matthew Fairclough
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.