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:
RE: OK, here goes... (1997)
default value from Lookup (was Grant, please help me) (1997)
[WebDNA] WebDNA 8.6.4 (2020)
[shownext max=?] armed (1997)
select multiple (1997)
b12 cannot limit records returned and more. (1997)
Card clearance, problems - solutions? (1997)
Frames (1997)
autocommit problem (1998)
guest book problem (2000)
OT: javascript help (2003)
HomePage Caution (1997)
WC Database Format (1997)
includes and cart numbers (1997)
en/decrypt with authenticate (2000)
WebCat2final1 crashes (1997)
pc (1997)
WebCat2: Items xx to xx shown, etc. (1997)
[BULK] [WebDNA] port from mime headers? (2017)
Alternating colors (1997)