well this is what i have come up with
forename = DBSession.query(AddressBookContact).filter(or_
(AddressBookContact.contact_forename.like('%'+str(kw['info'])+'%'),
AddressBookContact.contact_surname.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_email.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_address1.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_address2.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_street.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_town.like('%'+str(kw['info'])+'%'),
AddressBookContact.contact_county.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_postcode.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_country.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_telephone.like('%'+str(kw['info'])
+'%'),
AddressBookContact.contact_mobile.like('%'+str(kw['info'])
+'%'))).filter(AddressBookContact.system_website == website[0]).all()
it seems like a lot to search one table of information. Is this the
most sufficient way to search?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
