Aaaah, you'll laugh about this. In my transposition of the problem, I
failed to notice an errant ")". So the version I copied and pasted
into my email worked in the first place, but my actual code... did
something else.
Thank you very much for spelling it out, though. It's proved very much
worth m
On Wed, Mar 31, 2010 at 08:37:32AM +0800, Jason Heeris wrote:
> my_selection = dbase.Stock.select(
> sqlobject.sqlbuilder.AND(
> dbase.Stock.q.dbStockCode.startswith("XXX"),
> sqlobject.sqlbuilder.NOTIN(
>
On 30 March 2010 18:04, Oleg Broytman 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:
m
On Tue, Mar 30, 2010 at 11:58:36AM +0800, Jason Heeris wrote:
> sqlobject.sqlbuilder.Select(dbase.ContItem.q.dbStock, dbase.ContItem)
[skip]
> TypeError: iteration over non-sequence
The error I can see is the second parameter to Select(). You don't need
to pass the table class - Select derives
Hi,
This is on Python 2.5.5 with SQLObject 0.11.0 and MySQL 5.1.41-3 (on
Debian Squeeze).
I'm a little mystified about the SQLBuilder subselector NOTIN(). I
have the following MySQL query:
SELECT db_stock_code FROM stock WHERE
(db_stock_code LIKE "XXX%")
AND (id NOT IN (SELECT db_stock_
