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 [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
-~----------~----~----~----~------~----~------~--~---
