Re: Search on encrypted field
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30557
interpreted = N
texte = Have you looked in the database to see if any values exist in the encrypt_field? Have you tried storing normal data in that field and retreiving it?anup----- Original Message ----- From: Paul Fowler
To: WebCatalog Talk Sent: Monday, April 17, 2000 2:04 PM Subject: Re: Search on encrypted field > Yes, or no, the encrypt does not always produce the same code so I am out of > luck on that one(I just found it in my hard copy). But a comparison on > whether the field contains anything at all confuses me. > > My debugging line of the following shows me that the field is empty when I > know it has some encrypted information in it. > > [showif [encrypt_field]=] > Field has nothing in it [SKU] > [/showif] > > > > > > From: Anup setty > > Reply-To: (WebCatalog Talk) > > Date: Mon, 17 Apr 2000 13:54:55 > > To: (WebCatalog Talk) > > Subject: Re: Search on encrypted field > > > > Does the encrypt tag always produce the same encrypted code? > > If not you may not be able to find the required information from the > > database. > > > > anup > > > > > > ----- Original Message ----- > > From: Paul Fowler > > To: WebCatalog Talk > > Sent: Monday, April 17, 2000 1:44 PM > > Subject: Search on encrypted field > > > > > >> I'm having trouble searching and showing information conditionally from an > >> encrypted field. > >> > >> The encrypted information is entered by the following in a replace: > >> &encrypt_field=[url][encrypt > >> seed=(seed)][Uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url] > >> > >> And if I find this record in a search and then decrypt the field I get the > >> correct information back. > >> > >> Problem is, I need to show information conditionally if the encrypted > > field > >> matches user input. I have tried all the syntaxes to search on this field > >> that I can think of: > >> > >> &eqencrypt_fielddatarq=[url][encrypt > >> seed=(seed)][Uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url] > >> > >> &eqencrypt_fielddatarq=[encrypt > >> seed=(seed)][Uppercase][TEST_VAR][/Uppercase][/encrypt] > >> > >> Also if I do a [showif [encrypt_field]=] after finding all records the > >> result is True, but there are definitely something(albeit encrypted) in > > this > >> field. This result confuses me the most. > >> > >> I do remember reading a while back that there were problems searching on > > any > >> seed encrypted information, but I can't find it in the doc's now. > >> > >> Any suggestions why the strange results, and workarounds for this problem? > >> > >> Thanks for any light anyone can shine on this. > >> > >> > >> ------------------------------------------------------------- > >> 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 > > > >> > > > > > > ------------------------------------------------------------- > > 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 > > > > > ------------------------------------------------------------- > 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 ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
Have you looked in the database to see if any values exist in the encrypt_field? Have you tried storing normal data in that field and retreiving it?anup----- Original Message ----- From: Paul Fowler To: WebCatalog Talk Sent: Monday, April 17, 2000 2:04 PM Subject: Re: Search on encrypted field > Yes, or no, the encrypt does not always produce the same code so I am out of > luck on that one(I just found it in my hard copy). But a comparison on > whether the field contains anything at all confuses me. > > My debugging line of the following shows me that the field is empty when I > know it has some encrypted information in it. > > [showif [encrypt_field]=] > Field has nothing in it [SKU] > [/showif] > > > > > > From: Anup setty > > Reply-To: (WebCatalog Talk) > > Date: Mon, 17 Apr 2000 13:54:55 > > To: (WebCatalog Talk) > > Subject: Re: Search on encrypted field > > > > Does the encrypt tag always produce the same encrypted code? > > If not you may not be able to find the required information from the > > database. > > > > anup > > > > > > ----- Original Message ----- > > From: Paul Fowler > > To: WebCatalog Talk > > Sent: Monday, April 17, 2000 1:44 PM > > Subject: Search on encrypted field > > > > > >> I'm having trouble searching and showing information conditionally from an > >> encrypted field. > >> > >> The encrypted information is entered by the following in a replace: > >> &encrypt_field=[url][encrypt > >> seed=(seed)][uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url] > >> > >> And if I find this record in a search and then decrypt the field I get the > >> correct information back. > >> > >> Problem is, I need to show information conditionally if the encrypted > > field > >> matches user input. I have tried all the syntaxes to search on this field > >> that I can think of: > >> > >> &eqencrypt_fielddatarq=[url][encrypt > >> seed=(seed)][uppercase][ENCRYPT_VAR][/Uppercase][/encrypt][/url] > >> > >> &eqencrypt_fielddatarq=[encrypt > >> seed=(seed)][uppercase][TEST_VAR][/Uppercase][/encrypt] > >> > >> Also if I do a [showif [encrypt_field]=] after finding all records the > >> result is True, but there are definitely something(albeit encrypted) in > > this > >> field. This result confuses me the most. > >> > >> I do remember reading a while back that there were problems searching on > > any > >> seed encrypted information, but I can't find it in the doc's now. > >> > >> Any suggestions why the strange results, and workarounds for this problem? > >> > >> Thanks for any light anyone can shine on this. > >> > >> > >> ------------------------------------------------------------- > >> 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 > > > >> > > > > > > ------------------------------------------------------------- > > 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 > > > > > ------------------------------------------------------------- > 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 ------------------------------------------------------------- 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
Anup setty
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:
[showif] problem (1999)
Almost a there but..bye bye NetCloak (1997)
Getting total number of items ordered (1997)
retain raw [cart] submitted value (2004)
Mac: LModelDirector bug fix (1997)
[WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow (2019)
setitems, one more thing (1997)
fresh eyes needed. Append won't work. (2000)
Separate SSL Server (1997)
serial number dishing (1997)
Server slowing down. (1997)
shipcost (1997)
Trouble Searching (1999)
can WC render sites out? (1997)
P3P and IE 6 (2004)
Grep email addresses in bbedit or webdna ... (2003)
WCf2 and nested tags (1997)
HELP! Search finding too much! (1998)
WebTen and WebCat (1997)
Ads.db (1997)