Re: [search] & [encrypt]/[decrypt]

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38468
interpreted = N
texte = Hmmm, unpleasant. That's what I'm trying to avoid.James-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Bob McPeak Sent: Thursday, September 06, 2001 6:28 PM To: WebCatalog Talk Subject: Re: [search] & [encrypt]/[decrypt] You may have to return all results and decrypt. Then use an if/else or showif to make selections.> 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)
Hmmm, unpleasant. That's what I'm trying to avoid.James-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Bob McPeak Sent: Thursday, September 06, 2001 6:28 PM To: WebCatalog Talk Subject: Re: [search] & [encrypt]/[decrypt] You may have to return all results and decrypt. Then use an if/else or showif to make selections.> 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:

WC Database Format (1997) random prob (2003) [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (2012) Event Calendar (2004) help with autenticate (1998) Problem (1997) Configuring E-mail (1997) Version f1 status (1997) problems with 2 tags (1997) Online reference (1997) Security (1998) how do we turn off staticpages page creation? (2003) won't serve .tpl -index.tpl gone, made test.tpl (2000) Unix Timestamp using WebDNA [code req] (2003) Resume Catalog ? (1997) [Sum] function? (1997) Car Database (2002) There's no belittling going on here ... (2000) displaying New products (Yikes! it's Fixed!) (1997) On a related topic (2006)