I made a mistake and you have discovered something important.
a and b
it not the same as
a & b
queries you use '&', not 'and'. Example:
>>> class A():
... def __and__(self,other): print 'and'
...
>>> a=A()
>>> b=A()
>>> a and b
<__main__.A instance at 0xa8c60>
>>> a & b
and
the operator __and__ overloaded in the DAL is '&', not 'and'.
This means there is an error in the T2 example.
Massimo
On Oct 8, 3:58 am, vihang <[EMAIL PROTECTED]> wrote:
> for unknown reasons, the query suggested in the t2 examples did not
> work.
>
> listing_own=db.t2_person.id==db.listing_owner.person_id and
> db.Accomodation.id==db.listing_owner.Accomodation_id
>
> This is how it works
>
> listing_own=(db.t2_person.id==db.listing_owner.person_id) &
> (db.Accomodation.id==db.listing_owner.Accomodation_id)
>
> Vihang
>
> On Oct 6, 2:35 am, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > I will run some tests later tonight. Thanks for letting me know.
>
> > Massimo
>
> > On Oct 5, 12:24 pm, vihang <[EMAIL PROTECTED]> wrote:
>
> > > Thesearchfunction is not processing the query. I am yet to probe
> > > into this.
>
> > > Here's the issue
>
> > > in model
> > > db.define_table('listing_owner',
> > > SQLField('person_id',db.t2_person),
> > > SQLField('Accomodation_id',db.Accomodation))
>
> > > listing_own=db.t2_person.id==db.listing_owner.person_id and
> > > db.Accomodation.id==db.listing_owner.Accomodation_id
>
> > > in controller
> > >search=t2.search(db.t2_person,db.Accomodation, query=listing_own)
>
> > > result
>
> > > I get the combination of all the t2_person with Accomodation_id
>
> > > Any clue?
>
> > > Vihang
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
