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]OnBehalf Of Bob McPeakSent: Thursday, September 06, 2001 6:28 PMTo: WebCatalog TalkSubject: Re: [search] & [encrypt]/[decrypt]You may have to return all results and decrypt. Then use an if/else orshowif 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 valuein> 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 everyrecord> 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:
Hmmm, unpleasant. That's what I'm trying to avoid.James-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Bob McPeakSent: Thursday, September 06, 2001 6:28 PMTo: WebCatalog TalkSubject: Re: [search] & [encrypt]/[decrypt]You may have to return all results and decrypt. Then use an if/else orshowif 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 valuein> 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 everyrecord> 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:
PSC recommends what date format yr 2000??? (1997)
Country & Ship-to address & other fields ? (1997)
[FoundItems] solved - thanks (1997)
Associative lookup style? + bit more (1997)
Add to Cart & List of Products (1997)
Change Subtotal (2000)
WebCat for mass emailings (1997)
Multiple Merchant Accounts? (1997)
Parse question (2005)
carriage returns in data (1997)
Erotic Sites (1997)
Webcat XML/XSLT Performance vs. static Html (2006)
How to Sort Summ data ? (1997)
Add a field to the error log? (1997)
[WebDNA] Fwd: RETS... HELP! (2009)
Searching (2005)
[ConvertChars] problem (1997)
again (1998)
File Upload (1997)
GuestBook example (1997)