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
You're right but even with a WHERE statement I get the same programming
error, I have to use the dtml-sqlgroup statement
Françoise
2008/12/12 Andrew Milton a...@theinternet.com.au
+---[ Fran?oise CONIL ]--
| Trying :
|
| select * from mytable sqltest mylist
*Hello,
*My ZSQL method receive a *mylist* parameter that should be an integer list
: [21,35]
The following code does not work :
SELECT *
FROM MyTable
WHERE
id in
(dtml-in mylist
dtml-sqlvar sequence-item type=int dtml-if
sequence-lastdtml-else,/dtml-if
/dtml-in)
*Type de