Matthew Fairclough wrote:
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)
Ah, you do this from the test-tab of the ZSQL-Method? This is bad,
because every input there is treated as a string (especially if there
are "," in it)
Just write a simple Python-script in the same folder to test the
ZSQL-Method:
# See if the query is rendered correct:
print context.yourZSQLMethodName(clientAssocList=[4,5,6],src__=1)
print context.yourZSQLMethodName(clientAssocList=[4,5,6]).dictionaries()
return printed
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
HTH,
Wolfram
_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db
