Re: Search on encrypted field
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30559
interpreted = N
texte = I just seemed to fix it, but the only thing that I can tell that I did is to set the comparison variables before the showif instead of in it.some things don't always seem logical, you just have to try every possible way to do something before it works.Thanks for your helpPaul > From: Anup setty
> Reply-To: (WebCatalog Talk) > Date: Mon, 17 Apr 2000 14:28:06 > To: (WebCatalog Talk) > Subject: Re: Search on encrypted field > > 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 > ------------------------------------------------------------- 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:
I just seemed to fix it, but the only thing that I can tell that I did is to set the comparison variables before the showif instead of in it.some things don't always seem logical, you just have to try every possible way to do something before it works.Thanks for your helpPaul > From: Anup setty > Reply-To: (WebCatalog Talk) > Date: Mon, 17 Apr 2000 14:28:06 > To: (WebCatalog Talk) > Subject: Re: Search on encrypted field > > 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 > ------------------------------------------------------------- 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
Paul Fowler
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:
Separate SSL Server (1997)
file browser. (2002)
WebCat chatroom (1997)
Carts & cookies (1999)
filemaker - orderfile (1997)
WebCat2 - storing unformatted date data? (1997)
[WebDNA] [PROTECT] - Log Out (2011)
WebDNA wholesale ... (2002)
Waitfor file (2000)
taxTotal, grandTotal (1997)
Charting records by state (2000)
[WebDNA] Wrong email address (2008)
RE: Help name our technology! (1997)
File Format Validation (2005)
[ANN] GetRate 1.3 available (2000)
Re:Virtual hosting and webcatNT (1997)
Orderfile context problem (1998)
Dumb Question about Docs (1997)
SSL, WebSTAR, WebCatalog (1998)
WebCat2 - [SendNews] (1997)