Re: [WebDNA] Search encrypted field

This WebDNA talk-list message is from

2015

It keeps the original formatting. numero = 112386
interpreted = N
texte = --Apple-Mail=_27C71161-81E9-45DA-86F0-A9B92FFD6917Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Thanks, but I gave up.Yes they were encrypted with a key, and I can unencrypt them just fine. =20=I want the record numbers for the encrypted data =E2=80=9CJohn=E2=80=9D. =But if I searched using the encrypted value for John, WebDNA laughed at =me.>> [search db=3Dsomedab.db&eqNAMEdata=3D )#$)(#$#($*]WebDNA: ha ha ha ha ha ha=20So I ended up having to unencrypt to a temperate db, search the db to =get the record numbers I wanted, and then delete the temp DB.Messy, but it works.Thanks,FrankThis message is intended only for the user of the individual or entity =to which it is addressed and may contain information that is privileged, =confidential and exempt from disclosure under applicable law. If you are =not the intended recipient, you are hereby notified that any use, =dissemination, distribution or copying of this communication is strictly =prohibited. If you have received this communication to error, please =return this email to the sender, and destroy the original message> On Aug 9, 2015, at 4:53 PM, Donovan Brooke wrote:>=20> Are the values encrypted with a key? Maybe posting your code will =help.=20>=20> D. Brooke Mobile>=20>> On Aug 9, 2015, at 7:47 PM, C Frank Wolfe wrote:>>=20>> Hi,>>=20>> I think I=E2=80=99m making myself crazy trying to search for an =encrypted value.>>=20>> If I want to find all records with Fred, and fred is encrypted I =have to search for [search db=3Dsomedab.db&eqNAMEdata=3D )#$)(#$#($*]>> and that does not seem to make WebDNA very happy.>>=20>> Should I give up or is there some other way?>>=20>> Thanks,>>=20>> Frank>>=20>> WebDNA 4.5.1--------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list .>> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us--Apple-Mail=_27C71161-81E9-45DA-86F0-A9B92FFD6917Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8

Thanks, but I gave up.

Yes they were encrypted with a =key, and I can unencrypt them just fine.  

I want the record numbers for the encrypted =data =E2=80=9CJohn=E2=80=9D. But if I searched using =the encrypted value for John, WebDNA laughed at =me.

[search =db=3Dsomedab.db&eqNAMEdata=3D =)#$)(#$#($*]

WebDNA:  ha ha ha ha ha ha 

So I ended up =having to unencrypt to a temperate db, search the db to get the record numbers I =wanted, and then delete the temp DB.

Messy, but it =works.

Thanks,

Frank

This message is intended only for the user of the =individual or entity to which it is addressed and may contain =information that is privileged, confidential and exempt from disclosure =under applicable law. If you are not the intended recipient, you are =hereby notified that any use, dissemination, distribution or copying of =this communication is strictly prohibited. If you have received this =communication to error, please return this email to the sender, and =destroy the original message