Hello, I'm trying to use SQLObject with Firebird. However, I have problem with class like this:
class Phone(SQLObject):
uri = StringCol(alternateID=True, length=50)
username = UnicodeCol(length=50)
password = UnicodeCol(length=40)
When trying to retrieve objects, I get
File "/usr/lib/python2.4/site-packages/sqlobject/sresults.py", line 149, in
__iter__
return iter(list(self.lazyIter()))
File "/usr/lib/python2.4/site-packages/sqlobject/sresults.py", line 157, in
lazyIter
return conn.iterSelect(self)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py", line 361,
in iterSelect
select, keepConnection=False)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py", line 687,
in __init__
self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
File "/usr/lib/python2.4/site-packages/sqlobject/dbconnection.py", line 295,
in _executeRetry
return cursor.execute(query)
ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error
code = -104\n Token unknown - line 1, char 51\n password')
Is it possible that SQLObject do not escape column names?
--
Almad
pgpYKXY4ClBEv.pgp
Description: PGP signature
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
