just checked.. the search works fine now in t2,
one more thing, the input box value would do well with .strip() added
to remove whitespaces... they are definitely a problem with the
search.. but I was just wondering that would it be useful if its added
to the framework... I cannot think of any instance where I would want
a starting and trailing whitespaces when I capture a value from the
form... maybe others may have something to say.
On Oct 8, 8:25 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> 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 theT2example.
>
> Massimo
>
> On Oct 8, 3:58 am, vihang <[EMAIL PROTECTED]> wrote:
>
> > for unknown reasons, the query suggested in thet2examples 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
-~----------~----~----~----~------~----~------~--~---
