On 30 March 2010 18:04, Oleg Broytman <p...@phd.pp.ru> wrote:
> The error I can see is the second parameter to Select(). You don't need
> to pass the table class - Select derives it from the item ContItem.q.dbStock.
> The second parameter to Select is WHERE clause; if you don't need it just
> omit it.
Using:
my_selection = dbase.Stock.select(
sqlobject.sqlbuilder.AND(
dbase.Stock.q.dbStockCode.startswith("XXX"),
sqlobject.sqlbuilder.NOTIN(
sqlobject.sqlbuilder.Outer(dbase.Stock).q.id,
sqlobject.sqlbuilder.Select(dbase.ContItem.q.dbStock)))
... gives exactly the same error though.
Cheers,
Jason
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
