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
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 *
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;