Sorry, I still think your tables have something missing since q1 and
q2 reference fields that do not exist.
On Aug 17, 8:47 am, max <dulip.withan...@gmail.com> wrote:
> Sorry, made a failure in my posting. I corrected it now.
>
> First Table:
> my_db.define_table('details',
> SQLField('lokid'),
> SQLField(''details'),
> )
>
> Second table:
> my_db.define_table('keywords',
> SQLField('lokid',my_db.lokid))
> SQLField('lokid',my_db.keyword))
>
> my search form looks
> form2 = FORM(INPUT(_type="text", _name='my_search'), INPUT
> (_type='submit', _value="mySearch"))
>
> my queries are like:
>
> q1 = (my_db.details.titel.lower().like('%%%s%%' % my_search))
> q2 = (my_db.keywords.details.like('%%%s%%' % my_search))
>
> I have to search for keyword in table 'keywords' and get the lokid
> for table 'details' and show the values. At the same time i have to
> search the 'detai'ls table and show it's own values for the same
> query.
> Optimally i put both the results in a dictionary and sort and it and
> put in my view. My problem is how can i combine the search.
>
> On 17 Aug., 15:26, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > I do not understand. Moreover in
>
> > q1 = (my_db.details.titel.lower().like('%%%s%%' % my_search))
> > q1 = (my_db.keywords.schlagwortzo.like('%%%s%%' % my_search))
>
> > table details does not have a titel (nor title) field and table
> > keywords does not have a schlagwortzo field.
>
> > Something is missing.
>
> > On Aug 17, 8:19 am, max <dulip.withan...@gmail.com> wrote:
>
> > > I am having a small problem, that i can't solve using the example in
> > > book.
>
> > > I want to search in two tables for one search word and output only
> > > rows in one table. I can't write the joined statement using web2py DAL
> > > commands.
>
> > > First Table:
> > > my_db.define_table('details',
> > > SQLField('lokid'),
> > > SQLField(''details'),
> > > )
>
> > > Second table:
> > > my_db.define_table('keywords',
> > > SQLField('lokid',my_db.details))
>
> > > my search form looks
> > > form2 = FORM(INPUT(_type="text", _name='my_search'), INPUT
> > > (_type='submit', _value="mySearch"))
>
> > > my queries are like:
>
> > > q1 = (my_db.details.titel.lower().like('%%%s%%' % my_search))
> > > q1 = (my_db.keywords.schlagwortzo.like('%%%s%%' % my_search))
>
> > > I have to combine these commands.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
