In a function I have the following query:
labels = db(db.vtx_label.vertexID==vertexID)._select(db.vtx_label.label)
join = db.vtx_vertex.on((db.vtx_label.vertexID==db.vtx_vertex.id) &
(db.vtx_vertex.typeID==IOTHINGID))
rowset = db((db.vtx_label.label.belongs(labels)) &
(db.vtx_label.vertexID!=vertexID))
count = rowset.count()
rows = rowset.select(join=join)
The problem is that the rowset needs the join to count right, is there a
way to
solve this issue other then this:
labels = db(db.vtx_label.vertexID==vertexID)._select(db.vtx_label.label)
rowset = db((db.vtx_label.label.belongs(labels)) &
(db.vtx_label.vertexID!=vertexID) &
(db.vtx_label.vertexID==db.vtx_vertex.id) &
(db.vtx_vertex.typeID==IOTHINGID))
count = rowset.count()
rows = rowset.select()
I'd like to keep the join separate from the where clause.
Best,
Annet
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
