Hi,
I have the following model definitions:
db.define_table('bl_nationality',
Field('nationality', 'string')
)
db.define_table('bl_names',
Field('surname', 'string'),
Field('forename', 'string'),
Field('dob', 'date', requires=IS_DATE(format=T(''%Y-%m-%d'))),
Field('nationality', db.bl_nationality),
)
I'm trying to build a custom search form, which searches a database for
various values *depending upon what fields are filled.*
Now, I can build a dict of fields corresponding to *only* the filled-in
fields in the search form & parse that into a separate list of
db.bl_names.surname.contains(request.vars['surname']) type-objects.
My question is how do I combine all these separate objects into one
meta-query (as it were)?
I was trying something like this, but it doesn't seem to work:
###########
rows=db(my_sets[0])
for my_set in my_sets[1:]:
rows=db( rows & my_set)
return dict(rows=rows)
One of the more illuminating errors was (errinfo=(1064, u'42000', u"You have
an error in your SQL syntax; check th...'<gluon.dal.Set object at
0x03FBEB70>' at line 1"))
Any assistance or suggestions would be appreciated.
Martin
