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 you are 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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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:

    
  1. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Kenneth Grome 2009)
  2. [RESOLVED, I THINK] -- Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which can causes subsequent [search] to fail.) (John Butler 2009)
  3. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) ("Brian Harrington, Broker" 2009)
  4. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which can causes subsequent [search] to fail.) (Kenneth Grome 2009)
  5. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Kenneth Grome 2009)
  6. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (christophe.billiottet@webdna.us 2009)
  7. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  8. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which can causes subsequent [search] to fail.) (John Butler 2009)
  9. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Stuart Tremain 2009)
  10. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  11. [WebDNA] Re: [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  12. [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  13. Re: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  14. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  15. Re: [lookup] [search] Issue ( Brian Fries 2005)
  16. Re: [lookup] [search] Issue ( "Kenneth Grome" 2005)
  17. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  18. Re: [lookup] [search] Issue ( devaulw@onebox.com 2005)
  19. Re: [lookup] [search] Issue ( Mark Derrick 2005)
  20. Re: [lookup] [search] Issue ( Donovan Brooke 2005)
  21. Re: [lookup] [search] Issue ( nitai@computeroil.com 2005)
  22. [lookup] [search] Issue ( Mark Derrick 2005)
  23. Re: how to do [search] params on the fly? ( 2004)
  24. Re: how to do [search] params on the fly? ( Rob Marquardt 2004)
  25. Re: how to do [search] params on the fly? ( Donovan Brooke 2004)
  26. Re: how to do [search] params on the fly? ( Marc Thompson 2004)
  27. how to do [search] params on the fly? ( 2004)
  28. Re: [search] within [listfiles]? ( "Dan Strong" 2003)
  29. Re: [search] within [listfiles]? ( Alain Russell 2003)
  30. Re: [search] within [listfiles]? ( "Dan Strong" 2003)
  31. Re: [search] within [listfiles]? ( "Dan Strong" 2003)
  32. Re: [search] within [listfiles]? ( "Andrew Simpson" 2003)
  33. Re: [search] within [listfiles]? ( Alain Russell 2003)
  34. [search] within [listfiles]? ( "Dan Strong" 2003)
  35. Re: [search] sort problem (WJ Starck 2003)
  36. Re: [search] sort problem (Tim Robinson 2003)
  37. [search] sort problem (WJ Starck 2003)
  38. Re: Help with [search] sort (Gary Krockover 2003)
  39. Re: Help with [search] sort (Brian Fries 2003)
  40. Re: Help with [search] sort (WJ Starck 2003)
  41. Help with [search] sort (WJ Starck 2003)
  42. Re: This [search] worked before update to 4.5.1 (Kenneth Grome 2003)
  43. Re: This [search] worked before update to 4.5.1 (Brian Fries 2003)
  44. Re: This [search] worked before update to 4.5.1 (WJ Starck 2003)
  45. Re: This [search] worked before update to 4.5.1 (Gary Krockover 2003)
  46. Re: This [search] worked before update to 4.5.1 (Kenneth Grome 2003)
  47. Re: This [search] worked before update to 4.5.1 (WJ Starck 2003)
  48. Re: This [search] worked before update to 4.5.1 (Gary Krockover 2003)
  49. This [search] worked before update to 4.5.1 (WJ Starck 2003)
  50. Re: Feature Request : Separate [search] and [founditems] (John Peacock 2002)
  51. Feature Request : Separate [search] and [founditems] (charles kline 2002)
  52. Re: [search] & [encrypt]/[decrypt] (Kenneth Grome 2001)
  53. Re: [search] & [encrypt]/[decrypt] (Grant Hulbert 2001)
  54. Re: [search] & [encrypt]/[decrypt] (Brian Fries 2001)
  55. Re: [search] & [encrypt]/[decrypt] (James DeCambra 2001)
  56. Re: [search] & [encrypt]/[decrypt] (John Peacock 2001)
  57. Re: [search] & [encrypt]/[decrypt] (Grant Hulbert 2001)
  58. Re: [search] & [encrypt]/[decrypt] (Kenneth Grome 2001)
  59. Re: [search] & [encrypt]/[decrypt] (Grant Hulbert 2001)
  60. Re: [search] & [encrypt]/[decrypt] (James DeCambra 2001)
  61. Re: [search] & [encrypt]/[decrypt] (James DeCambra 2001)
  62. Re: [search] & [encrypt]/[decrypt] (Grant Hulbert 2001)
  63. Re: [search] & [encrypt]/[decrypt] (Bob McPeak 2001)
  64. [search] & [encrypt]/[decrypt] (James DeCambra 2001)
  65. Re: [search] resources (Parker 2000)
  66. Re: [search] resources (code.. longish sorry) (John Hill 2000)
  67. [search] resources (code.. longish sorry) (Parker 2000)
  68. Re: [Search] on Remote Database (WebDNA Support 2000)
  69. [Search] on Remote Database (Clint Davis 2000)
  70. Re: [search] and [shownext] Problem (Howard Wolosky 2000)
  71. Re: [search] and [shownext] Problem (Jesse Proudman 2000)
  72. [search] and [shownext] Problem (Richard Kirsner 2000)
  73. Re: more trouble with [showif] in [search] = busted [shownext] (John Butler 2000)
  74. Re: more trouble with [showif] in [search] = busted [shownext] - SOLVED (John Butler 2000)
  75. Re: more trouble with [showif] in [search] = busted [shownext] (Kenneth Grome 2000)
  76. Re: more trouble with [showif] in [search] = busted [shownext] (John Butler 2000)
  77. Re: more trouble with [showif] in [search] = busted [shownext] (Kenneth Grome 2000)
  78. more trouble with [showif] in [search] = busted [shownext] (John Butler 2000)
  79. Re: [showif]'s inside [search] params? (John Butler 2000)
  80. Re: [showif]'s inside [search] params? (Brian Boegershausen 2000)
  81. [showif]'s inside [search] params? (John Butler 2000)
  82. Re: [text] variable assignment within [search] context (Dennis J. Bonsall, Jr. 2000)
  83. Re: [text] variable assignment within [search] context (Brian Boegershausen 2000)
  84. Re: [text] variable assignment within [search] context (PCS Technical Support 2000)
  85. [text] variable assignment within [search] context (Dennis J. Bonsall, Jr. 2000)
  86. Re: Sunday [search] puzzler (Will Starck 1999)
  87. Sunday [search] puzzler (Will Starck 1999)
  88. Re: Embedded [Search] Context Snippets (Very Useful) (Kenneth Grome 1998)
  89. Re: Embedded [Search] Context Snippets (Very Useful) (John Hill 1998)
  90. Re: Embedded [Search] Context Snippets (Very Useful) (Kenneth Grome 1998)
  91. Embedded [Search] Context Snippets (Very Useful) (John Hill 1998)
  92. Re: [SEARCH] Context for SKU prices not working... (Michael Winston 1998)
  93. Re: [SEARCH] Context for SKU prices not working... (Kenneth Grome 1998)
  94. Re: [SEARCH] Context for SKU prices not working... (Michael Winston 1998)
  95. [SEARCH] Context for SKU prices not working... (Dale Stokdyk 1998)
  96. Re: [search] in formulas.db (Grant Hulbert 1997)
  97. [search] in formulas.db (Mike Heininger 1997)
  98. Re: Problem with [Search] inside of [Loop]? (Grant Hulbert 1997)
  99. Problem with [Search] inside of [Loop]? (Steve Rosenbaum 1997)
  100. RE: Nested [SEARCH] and [REPLACE] problem. (Marc Eagle 1997)
  101. Nested [SEARCH] and [REPLACE] problem. (Michael Winston 1997)
  102. Re:no [search] with NT (Grant Hulbert 1997)
  103. Re:no [search] with NT (bob 1997)
  104. Re:no [search] with NT (Kenneth Grome 1997)
  105. Re:no [search] with NT (Grant Hulbert 1997)
  106. Re:no [search] with NT (Kenneth Grome 1997)
  107. Re:no [search] with NT (Grant Hulbert 1997)
  108. Re:no [search] with NT (Kenneth Grome 1997)
  109. Re:no [search] with NT (Grant Hulbert 1997)
  110. Re:no [search] with NT (Kenneth Grome 1997)
  111. Re:no [search] with NT (Kenneth Grome 1997)
  112. Re:no [search] with NT (Grant Hulbert 1997)
  113. Re:no [search] with NT (Kenneth Grome 1997)
  114. Re: no [search] with NT (Kenneth Grome 1997)
  115. Re: no [search] with NT (Grant Hulbert 1997)
  116. Re:no [search] with NT (Jay Van Vark 1997)
  117. no [search] with NT (ken@iav.com 1997)
  118. Re: [SearchString] problem with [search] context (John Hill 1997)
  119. Re: [SearchString] problem with [search] context (Kenneth Grome 1997)
  120. Re: [SearchString] problem with [search] context (John Hill 1997)
  121. Re: [SearchString] problem with [search] context (Kenneth Grome 1997)
  122. Re: [SearchString] problem with [search] context (John Hill 1997)
  123. Re: [SearchString] problem with [search] context (Kenneth Grome 1997)
  124. Re: [SearchString] problem with [search] context (John Hill 1997)
  125. Re: [SearchString] problem with [search] context (Christer Olsson 1997)
  126. [SearchString] problem with [search] context (Kenneth Grome 1997)
  127. Problems with [Search] param - Mac Plugin b15 (Britt T. 1997)
  128. Re: Problems with [Search] param - Mac Plugin b15 (John Hill 1997)
  129. Re: WebCat2b12plugin - [search] is broken ... not! (Grant Hulbert 1997)
  130. WebCat2b12plugin - [search] is broken ... not! (Kenneth Grome 1997)
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 you are 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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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:

WC2f3 (1997) [OT] md5 or sha-1 on OSX (2007) Extended [Convertchars] needed (1997) Unexpected error (1997) taxRate is fine but taxTotal isn't (1997) WebCat & WebTen (1997) 'does not contain' operator needed ... (1997) WSDL Wizard (2003) RE: Credit Card Checksum (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Date problems-more (1997) Calculating multiple shipping... (1997) Serious bug writing to a database ... (2002) Clearing orders and database help! (1997) Thanks and Big News!!! (1997) [GROUPS] followup (1997) Converting Aliases to Symbolic Links (2002) New WebCatalog Version !!! (1997) country of origin from IPADDRESS??? (2001) target=_blank and form variables (1997)