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:
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)