[search] & [encrypt]/[decrypt]

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38464
interpreted = N
texte = 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?**Successful attempt** (SHOPPINGCART happens to not be encrypted, data comes out clean) [search db=[ord-db]&geSHOPPINGCARTdata=1&asSHOPPINGCARTsort=1]**Successful attempt** (CUSTOMER_ID is encrypted, I'm looking for any record with non-zero value in CUSTOMER_ID) (data comes out clean) [search db=[ord-db]&geCUSTOMER_IDdata=1&asSHOPPINGCARTsort=1]**Failed attempt** (CUSTOMER_ID is encrypted, I'm looking for all records with 83837 value in CUSTOMER_ID) [search db=[ord-db][!] [/!]&eqCUSTOMER_IDdata=[url][url][encrypt seed=[123abc]]83837[/encrypt][/url][/url][!] [/!]&asSHOPPINGCARTsort=1] I could probably put together some work around that would read every record but would [hideif] if it doesn't find the right condition but that seems a bit hokey. James ------------------------------------------------------------- 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)
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?**Successful attempt** (SHOPPINGCART happens to not be encrypted, data comes out clean) [search db=[ord-db]&geSHOPPINGCARTdata=1&asSHOPPINGCARTsort=1]**Successful attempt** (CUSTOMER_ID is encrypted, I'm looking for any record with non-zero value in CUSTOMER_ID) (data comes out clean) [search db=[ord-db]&geCUSTOMER_IDdata=1&asSHOPPINGCARTsort=1]**Failed attempt** (CUSTOMER_ID is encrypted, I'm looking for all records with 83837 value in CUSTOMER_ID) [search db=[ord-db][!] [/!]&eqCUSTOMER_IDdata=[url][url][encrypt seed=[123abc]]83837[/encrypt][/url][/url][!] [/!]&asSHOPPINGCARTsort=1] I could probably put together some work around that would read every record but would [hideif] if it doesn't find the right condition but that seems a bit hokey. James ------------------------------------------------------------- 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/ James DeCambra

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:

Log-in Scheme (2003) 40,000+ items = mutiple dbs? (1999) MacAuthorize (1999) [OT] ODBC between IIS and remote Access problem (2000) RE: Can a database get stomped by simultaneous access? (1997) PCS Frames (1997) WebCatalog/Mac 2.1b2 New Features (1997) E-Mail Preferences in Admin Folder (1997) WebCat2b15MacPlugin - showing [math] (1997) Show Databases in admin (2000) Setting up the server (1997) Rhapsody? (1997) switching users (1998) ANNC: BannerSleuth v2.0 Beta 1 (1999) ShowNext Command (1997) [WebDNA] JSONStore Levels (2020) Running a store on BOTH http and https (1998) LetterRip and WebCat & more (1998) Web Logs (1998) Forms to db's and back (was Displaying text and (2005)