Search on encrypted field
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30553
interpreted = N
texte = I'm having trouble searching and showing information conditionally from an encrypted field.The encrypted information is entered by the following in a replace: &encrypt_field=[url][encrypt seed=(seed)][Uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url]And if I find this record in a search and then decrypt the field I get the correct information back.Problem is, I need to show information conditionally if the encrypted field matches user input. I have tried all the syntaxes to search on this field that I can think of:&eqencrypt_fielddatarq=[url][encrypt seed=(seed)][Uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url]&eqencrypt_fielddatarq=[encrypt seed=(seed)][Uppercase][TEST_VAR][/Uppercase][/encrypt]Also if I do a [showif [encrypt_field]=] after finding all records the result is True, but there are definitely something(albeit encrypted) in this field. This result confuses me the most.I do remember reading a while back that there were problems searching on any seed encrypted information, but I can't find it in the doc's now.Any suggestions why the strange results, and workarounds for this problem?Thanks for any light anyone can shine on this. ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
I'm having trouble searching and showing information conditionally from an encrypted field.The encrypted information is entered by the following in a replace: &encrypt_field=[url][encrypt seed=(seed)][uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url]And if I find this record in a search and then decrypt the field I get the correct information back.Problem is, I need to show information conditionally if the encrypted field matches user input. I have tried all the syntaxes to search on this field that I can think of:&eqencrypt_fielddatarq=[url][encrypt seed=(seed)][uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url]&eqencrypt_fielddatarq=[encrypt seed=(seed)][uppercase][TEST_VAR][/Uppercase][/encrypt]Also if I do a [showif [encrypt_field]=] after finding all records the result is True, but there are definitely something(albeit encrypted) in this field. This result confuses me the most.I do remember reading a while back that there were problems searching on any seed encrypted information, but I can't find it in the doc's now.Any suggestions why the strange results, and workarounds for this problem?Thanks for any light anyone can shine on this. ------------------------------------------------------------- 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
Paul Fowler
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:
Fields/Forms Processing (1998)
syntax question, not in online refernce (1997)
Too many webcat comments. [WAS- Large founditems loops] (2000)
Logging purchases (1997)
WebDNA EMail Preference (2005)
Webstar 1.3.1 PPC (1997)
Problems with AOHell (1999)
WebCat2 - Getting to the browser's username/password data (1997)
webten vs. webstar (1998)
[returnraw] and form variables (1998)
Wanted: Broader string manipulation functions (1997)
Username for Admin Group (1997)
ShowNext Command (1997)
[WebDNA] OT: How is this being done? Curious. (2009)
apparently to problem isolated (1997)
Re:Problem (1997)
major search problem (1998)
Searching multiple Databases (1997)
service stop and restart (1997)
RE: Include (1998)