Re: [search] & [encrypt]/[decrypt]
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38480
interpreted = N
texte = James DeCambra wrote:> > I've encrypted a number of fields, written them to a database, and I've> successfully read the data and decrypted it with no problems. My question> is how do I perform a selective [search] on one of the encrypted fields?> As a rule, only encrypt fields that _have_ to be encrypted (like CC# or password). You are only wasting CPU encrypting/decrypting fields. You would be better off if you never encrypted any field that you intended to search, IMHO.However, as Grant states (and he should know), it's all text so if youare sure you know what you are searching for, you should be able to search encrypted fields. And, if it wasn't clear from Grant's e-mail,that means only whole field searchs; no substring searching allowed.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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:
James DeCambra wrote:> > I've encrypted a number of fields, written them to a database, and I've> successfully read the data and decrypted it with no problems. My question> is how do I perform a selective [search] on one of the encrypted fields?> As a rule, only encrypt fields that _have_ to be encrypted (like CC# or password). You are only wasting CPU encrypting/decrypting fields. You would be better off if you never encrypted any field that you intended to search, IMHO.However, as Grant states (and he should know), it's all text so if youare sure you know what you are searching for, you should be able to search encrypted fields. And, if it wasn't clear from Grant's e-mail,that means only whole field searchs; no substring searching allowed.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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/
John Peacock
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:
Dummy Credit Card Number for debug? (1997)
WCS Newbie question (1997)
Sendmail & Time Issue (2001)
RAM variables (1997)
Permission denied? (2004)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Languages (1997)
Security Hole - NetCloak Update (1998)
[random] only for 1-100??? (1997)
5.0 Preview Promotion Extension (2003)
ODBC to WebCat (2000)
WC2f3 (1997)
Trouble with Netscape (1998)
can WC render sites out? (1997)
serial number (1998)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
WebCatalog2 Feature Feedback (1996)
RE: Error: template (1997)
hideif/showif causes error if wrapped around searches (2003)
[Announce]: Web server security and password protection (1997)