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:
WebCat2 - Getting to the browser's username/password data (1997)
Three new problems, maybe a fourth (1997)
Help! WebCat2 bug (Ben's input) (1997)
b12 cannot limit records returned and more. (1997)
Generating and appending SKU to a db automatically (1998)
setitems, one more thing (1997)
re:check boxes (1997)
[ShowNext] feature in 2.0 (1997)
greater than or equal to (1997)
Adding up line items. (2000)
Weird error/limit - something amiss? (1997)
How far do [showif]s go? (1997)
WC2.0 Memory Requirements (1997)
Search wbrk (repost) (2001)
Falsifying [BROWSERNAME] (1998)
oi ...emailer (2002)
Is Web Merchant Necessary? (2000)
problem 'building' field names (2000)
Shell scripts with sudoer (2004)
Applescript error (1998)