ps: by the way, would be nice to have a shortcut 
db( (db.MatchPlayers.player==playerID) & (db.MatchPlayers.match_.started == 
None) ).

(for me it didn't work, but in in W2P nonquery syntax this works (and in 
Django such magic works i queries, if I recon  correctly )

2013 m. liepa 11 d., ketvirtadienis 15:17:46 UTC+3, Jurgis Pralgauskis rašė:
>
> db( (db.MatchPlayers.player==playerID) & (db.MatchPlayers.match_ == 
> db.Matches.id) & (db.Matches.started == None) ).delete()
>
> gives:
>
> raise RuntimeError("Too many tables selected")
>
> any hints?
>
>
> http://web2py.com/books/default/chapter/29/06#count,-isempty,-delete,-update
>  
> I don't find examples for similar cases
>
> I could select first , and then loop deleting records of needed table ... 
> but would be not very efficiet
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to