Re: Search on encrypted field

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30555
interpreted = N
texte = 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Search on encrypted field (Paul Fowler 2000)
  2. Re: Search on encrypted field (Anup setty 2000)
  3. Re: Search on encrypted field (Paul Fowler 2000)
  4. Re: Search on encrypted field (Anup setty 2000)
  5. Search on encrypted field (Paul Fowler 2000)
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 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:

HELP WITH DATES (1997) Disappearing HTML/WebDNA (1998) remove line item (2000) chicken / egg::purchase / setheader (2002) Help getting [shownext] to increment (2003) BBEdit and WebCatalog 2.0? (1997) WebCat2final1 crashes (1997) Adding repeating events to a database (2001) [taxrate] question (1997) Public beta 3 of WebCatalog 4.0 is now available (2000) Append File help needed (2000) # fields limited? (1997) Date Help! (2003) [SameAsShipping] (2005) sorting and summarizing (1998) snicker, snicker (1997) cookies and [returnraw] (1997) Grep Question (2003) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Mac app. that converts e-mails (2000)