[Zope] Cannot pass parameters to Externa Method From inside a DTML Method

2005-08-04 Thread Thomas Apostolou
I have in my Extensions folder the file TestODBCEM.py witch contains the following code to select and return 40 rows by 8 columns of a query: def TestODBCEM(self, sysDSN=defDSN, usr=defUsr, mypass=defPass, sSQL=SELECT * FROM defTable, xx=40, yy=8): id = self.id import dbi import odbc

Re: [Zope] Cannot pass parameters to Externa Method From inside a DTML Method

2005-08-04 Thread Tino Wildenhain
Am Donnerstag, den 04.08.2005, 11:31 +0100 schrieb Thomas Apostolou: I have in my Extensions folder the file TestODBCEM.py witch contains the following code to select and return 40 rows by 8 columns of a query: def TestODBCEM(self, sysDSN=defDSN, usr=defUsr, mypass=defPass, sSQL=SELECT *

Re: Re: [Zope] Cannot pass parameters to Externa Method From inside a DTML Method

2005-08-04 Thread Thomas Apostolou
This is not a good idea anyway. 1) it lets every user knowing the external method connect to every database on your host (depending on credentials if any) 2) even worser it enables the user to issue any raw SQL string to the database, including but not limited to DROP table;