Re: [search] & [encrypt]/[decrypt]
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38473
interpreted = N
texte = >>I double-urled to write to the db, so I'm only as sure as that.>>>>At your suggestion I tried the [search] with a single url and with no url>>and neither worked.>>>>Are you ~supposed~ to be able to do selective reads against encrypted data,>>or am I making a bad assumption?Webcat reportedly creates a different encryption string, or at least not the exact same string, every time it performs an encryption on the same original string. This makes it impossible to do a comparison matching search on the field the encrypted string in stored in. therefore, there are two alternatives I can think of offhand to search on a field that has encrypted data in it:1- retrieve all records in the db, then ...2- decrypt every encrypted value (inside the founditems context) in the field you need to search, then ...3- use showif's and hideif's to determine which decrypted values match the original value.*OR* ...1- retrieve all records in the db, then ...2- decrypt every encrypted value and write them all to a temporary database, then ...3- search the temp db for the matching value which is not in its original unencrypted format.I think the first solution would be faster, but it might be worth testing them both to make sure.:)----------------------------------------------------Kenneth Grome & Associatesweb: http://kengrome.comemail: owner@kengrome.commobile: +63 917 254-1494office: +63 32 262-8164-----------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>>I double-urled to write to the db, so I'm only as sure as that.>>>>At your suggestion I tried the [search] with a single url and with no url>>and neither worked.>>>>Are you ~supposed~ to be able to do selective reads against encrypted data,>>or am I making a bad assumption?Webcat reportedly creates a different encryption string, or at least not the exact same string, every time it performs an encryption on the same original string. This makes it impossible to do a comparison matching search on the field the encrypted string in stored in. therefore, there are two alternatives I can think of offhand to search on a field that has encrypted data in it:1- retrieve all records in the db, then ...2- decrypt every encrypted value (inside the founditems context) in the field you need to search, then ...3- use showif's and hideif's to determine which decrypted values match the original value.*OR* ...1- retrieve all records in the db, then ...2- decrypt every encrypted value and write them all to a temporary database, then ...3- search the temp db for the matching value which is not in its original unencrypted format.I think the first solution would be faster, but it might be worth testing them both to make sure.:)----------------------------------------------------Kenneth Grome & Associatesweb: http://kengrome.comemail: owner@kengrome.commobile: +63 917 254-1494office: +63 32 262-8164-----------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[append] (1997)
country of origin from IPADDRESS??? (2001)
[WebDNA] RE: webdna right click protect (2009)
Problems searching from a FORM (1997)
MacFinder -- a new WebDNA web site (1998)
Date Formats (1997)
problems with 2 tags (1997)
Limit to variables being passed??? (1998)
About to give up (1998)
PIXO (1997)
PHP Live (2005)
Adding extra coding on the fly? (2005)
Bug? (1997)
[WebDNA] Email delivery problems? (2010)
Forms Search Questions (1997)
Country & Ship-to address & other fields ? (1997)
strange [Shell] things / Linux (2000)
[SearchString] problem with [search] context (1997)
normal users.db calls ... (1998)
HELP WITH DATES (1997)