Re: [search] & [encrypt]/[decrypt]
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38466
interpreted = N
texte = You may have to return all results and decrypt. Then use an if/else orshowif to make selections.----- Original Message -----From: James DeCambra
To: WebCatalog Talk Sent: Thursday, September 06, 2001 8:58 PMSubject: [search] & [encrypt]/[decrypt]> 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/-------------------------------------------------------------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:
You may have to return all results and decrypt. Then use an if/else orshowif to make selections.----- Original Message -----From: James DeCambra To: WebCatalog Talk Sent: Thursday, September 06, 2001 8:58 PMSubject: [search] & [encrypt]/[decrypt]> 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/-------------------------------------------------------------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/
Bob McPeak
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:
date display (1999)
2.0.1 new commands and contexts (1997)
Emailer help....! (1997)
WC2.0 Memory Requirements (1997)
Norton Internet Security filtering out WebDNA processsed (2004)
dates and hex formatting (1997)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
question: webdelivery folder and file (1997)
Db crash in win98 (2000)
IIS and 4.0.1b1 (2000)
Sorting Numbers (1997)
add to cart within a page? (1997)
Canada oh Canada (2004)
How to Sort Summ data ? (1997)
Problems mit mysql (2004)
Smith Micro Support powerd by PHP (2006)
Append again (1999)
Order problem (1998)
WebCat chatroom (1997)
Can this be done? (1997)