Re: [SQLObject] Delete with LIKE statement

2007-12-13 Thread Leandro Sales
2007/12/13, Oleg Broytmann <[EMAIL PROTECTED]>: > > On Thu, Dec 13, 2007 at 02:16:15PM -0300, Leandro Sales wrote: > > class DBObject(InheritableSQLObject): > > title = UnicodeCol(length=100, default="") > > > > class DBItem(DBObject, InheritableSQLObject): > > local_path = UnicodeCol(lengt

Re: [SQLObject] Delete with LIKE statement

2007-12-13 Thread Oleg Broytmann
On Thu, Dec 13, 2007 at 02:16:15PM -0300, Leandro Sales wrote: > class DBObject(InheritableSQLObject): > title = UnicodeCol(length=100, default="") > > class DBItem(DBObject, InheritableSQLObject): > local_path = UnicodeCol(length=1000, default="") > > If I do: > DBItem.deleteMany(LIKE(

Re: [SQLObject] Delete with LIKE statement

2007-12-13 Thread Leandro Sales
Hello Oleg, It doesn't worked for me: Please, consider the following scenario: class DBObject(InheritableSQLObject): title = UnicodeCol(length=100, default="") class DBItem(DBObject, InheritableSQLObject): local_path = UnicodeCol(length=1000, default="") If I do: DBItem.deleteMany(LI

Re: [SQLObject] Delete with LIKE statement

2007-12-12 Thread Oleg Broytmann
On Wed, Dec 12, 2007 at 07:11:56PM -0300, Leandro Sales wrote: > DELETE FROM db_item WHERE db_item.local_path LIKE ' " + local_path + "%' " from sqlobject.sqlbuilder import LIKE DBItem.deleteMany(LIKE(DBItem.q.local_path, '...')) Oleg. -- Oleg Broytmannhttp://phd.pp.ru/