BTW, why do you want to protect idName, id and so on?
On Thu, Apr 13, 2006 at 05:12:20PM -0500, Charles Duffy wrote:
> if columns:
> return self.queryOne(
> - "SELECT %s FROM %s WHERE %s = %s" %
> + "SELECT %s FROM %s WHERE (%s) = (%s)" %
> (columns,
> so.sqlmeta.table,
> so.sqlmeta.idName,
> self.sqlrepr(so.id)))
> else:
> return self.queryOne(
> - "SELECT NULL FROM %s WHERE %s = %s" %
> + "SELECT NULL FROM %s WHERE (%s) = (%s)" %
> (so.sqlmeta.table,
> so.sqlmeta.idName,
> self.sqlrepr(so.id)))
> @@ -643,20 +643,20 @@
> condition))
>
> def _SO_delete(self, so):
> - self.query("DELETE FROM %s WHERE %s = %s" %
> + self.query("DELETE FROM %s WHERE (%s) = (%s)" %
> (so.sqlmeta.table,
> so.sqlmeta.idName,
> self.sqlrepr(so.id)))
>
> def _SO_intermediateJoin(self, table, getColumn, joinColumn, value):
> - return self.queryAll("SELECT %s FROM %s WHERE %s = %s" %
> + return self.queryAll("SELECT %s FROM %s WHERE (%s) = (%s)" %
> (getColumn,
> table,
> joinColumn,
> Index: sqlobject/main.py
> ===================================================================
> --- sqlobject/main.py (revision 1695)
> +++ sqlobject/main.py (working copy)
> @@ -1483,7 +1483,7 @@
> if col.cascade == False:
> # Found a restriction
> restrict = True
> - query.append("%s = %s" % (col.dbName, self.id))
> + query.append("%s = (%s)" % (col.dbName, self.id))
???
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
