Hmm, what version of web2py? I cannot reproduce this error. Anyway, you can
try using the alternative method of forming conjunctions by chaining calls
to db():
query1 = 'instr(microelementexamplestest.example,microelementstest.element)'
query2 = db.microelementexamplestest.verificationstatus.belongs((0,2))
db(query1)(query2).select(...)
Other options might be:
db('%s AND %s' % (query1, str(query2))).select(...)
or:
from gluon.dal import Query
db(Query(db, query1) & query2).select(...)
Anthony
On Monday, September 8, 2014 3:18:53 AM UTC-4, Gliese 581 g wrote:
>
> I have two tables - element and example. I want to find element like items
> in example table but their status should either be 0 or 2.
>
> I have written a query to fetch records from two tables as given below:
>
>
> rows=db(('instr(microelementexamplestest.example,microelementstest.element)')
> &
> (db.microelementexamplestest.verificationstatus.belongs((0,2)))).select(
> db.microelementstest.id,db.microelementexamplestest.id
> ,db.microelementexamplestest.verificationstatus)
>
> But I get this error : TypeError: unsupported operand type(s) for &: 'str'
> and 'Query'".
>
> Please help me to fix this.
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
