: Françoise CONIL
To: zope@zope.org
Sent: Thursday, December 11, 2008 11:21 AM
Subject: [Zope] Problem using dtml-in in ZSQL method
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
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
+---[ Fran?oise CONIL ]--
| Trying :
|
| select * from mytable sqltest mylist multiple type=int column=id
select * from mytable WHERE sqltest mylist multiple type=int column=id
^
Missed a where statement...
| Thanks for your reply
No
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
: [Zope] Problem using dtml-in in ZSQL method
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
: Françoise CONIL
To: zope@zope.org
Sent: Thursday, December 11, 2008 11:21 AM
Subject: [Zope] Problem using dtml-in in ZSQL method
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
| - Original Message -
| From: Fran?oise CONIL
| To: zope@zope.org
| Sent: Thursday, December 11, 2008 11:21 AM
| Subject: [Zope] Problem using dtml-in in ZSQL method
|
|
| Hello,
|
| My ZSQL method receive a *mylist* parameter that should be an integer list :
| [21,35
+---[ Andrew Milton ]--
| | - Original Message -
| | From: Fran?oise CONIL
| | To: zope@zope.org
| | Sent: Thursday, December 11, 2008 11:21 AM
| | Subject: [Zope] Problem using dtml-in in ZSQL method
| |
| |
| | Hello,
| |
| | My ZSQL method receive a *mylist