I'm trying to use this
https://groups.google.com/d/msg/web2py/uGFQD0PBefQ/Zi-SPOLVSXIJ for
encrypting data in a sqlite table.
I need to search in one field with 'like' operator for buil a ajax list, i
use this function:
def ajaxlivesearch():
partialstr = request.vars.values()[0]
query = db.Nominativi.nome.like('%'+partialstr+'%')
person = db(query).select(db.Nominativi.nome,db.Nominativi.id,db.
Nominativi.categoria)
items = []
for (i,person) in enumerate(person):
try:
items.append(LI(A(person.nome,' -->
',person.categoria.categoria,_href
=URL('default','nominativo',args=person.id))))
except:
print "errore nel generare l'elemento"
return TAG[''](*items)
when i try to serch in encrypted field with web2py query i don't get any
result :( also in admin interface.
Filter_out does not work in searches?
Might be useful to create a temporary virtual table with the decrypted data
for the search and keep it active only for the session? How can I do that?
.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
