[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'vesuccessfully read the data and decrypted it with no problems. My questionis 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 inCUSTOMER_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 inCUSTOMER_ID) [search db=[ord-db][!] [/!]&eqCUSTOMER_IDdata=[url][url][encryptseed=[123abc]]83837[/encrypt][/url][/url][!] [/!]&asSHOPPINGCARTsort=1]I could probably put together some work around that would read every recordbut would [hideif] if it doesn't find the right condition but that seems abit 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:
I've encrypted a number of fields, written them to a database, and I'vesuccessfully read the data and decrypted it with no problems. My questionis 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 inCUSTOMER_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 inCUSTOMER_ID) [search db=[ord-db][!] [/!]&eqCUSTOMER_IDdata=[url][url][encryptseed=[123abc]]83837[/encrypt][/url][/url][!] [/!]&asSHOPPINGCARTsort=1]I could probably put together some work around that would read every recordbut would [hideif] if it doesn't find the right condition but that seems abit 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)