Re: [WebDNA] Search encrypted field

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112384
interpreted = N
texte = --Apple-Mail=_C61195E5-59A1-4AE1-BF8D-0100109326CB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I don=E2=80=99t really need to search for )#$)(#$#($ but don=E2=80=99t = know how else to do it. I think Stuart=E2=80=99s idea of undecrypting to a table might be a good = answer. This site is on 4.5.1 and don=E2=80=99t think it does tables, but I = could do a temp db. I will try your [url] too, that would be the easiest =20 Thanks, 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 > On Aug 9, 2015, at 3:18 PM, Dan Strong wrote: >=20 > Do you mean you want to literally search for the string ")#$)(#$#($*" = (or whatever) or do you want to decrypt it first? >=20 > If the former, can you [url] the values in the database and then = search for [url])#$)(#$#($*[/url] >=20 > -Dan Strong > http://danstrong.com > http://sw.amphou.se > On Sun, Aug 9, 2015 at 6:15 PM, Stuart Tremain > wrote: > You may have to extract all the records into an unencrypted table and = then search the table. >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 > > On 10 Aug 2015, at 10:47, C Frank Wolfe > wrote: > > > > Hi, > > > > I think I=E2=80=99m making myself crazy trying to search for an = encrypted value. > > > > 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. > > > > Should I give up or is there some other way? > > > > Thanks, > > > > Frank > > > > 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 >=20 > --------------------------------------------------------- > 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 >=20 > --------------------------------------------------------- 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=_C61195E5-59A1-4AE1-BF8D-0100109326CB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I don=E2=80=99t really need to search = for )#$)(#$#($ but don=E2=80=99t know how else to do it.

I think Stuart=E2=80=99s idea of undecrypting to a table = might be a good answer.

This site is on 4.5.1 and = don=E2=80=99t think it does tables, but I could do a temp = db.

I will try your [url] too, = that would be the easiest   

Thanks,


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

On Aug 9, 2015, at 3:18 PM, Dan Strong <dan@danstrong.com> = wrote:

Do you mean you want to literally search for the = string ")#$)(#$#($*" (or whatever) or do you want to decrypt it = first?

If = the former, can you [url] the values in the database and then search for = [url])#$)(#$#($*[/url]


On Sun, Aug 9, 2015 at 6:15 = PM, Stuart Tremain <webdna@idfk.com.au> wrote:
You may have to = extract all the records into an unencrypted table and then search the = table.



Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au





> On 10 Aug 2015, at 10:47, C Frank Wolfe <frank@cwolfe.com> = wrote:
>
> Hi,
>
> I think I=E2=80=99m making myself crazy trying to search for an = encrypted value.
>
> 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.
>
> Should I give up or is there some other way?
>
> Thanks,
>
> Frank
>
> WebDNA = 4.5.1---------------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> 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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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=_C61195E5-59A1-4AE1-BF8D-0100109326CB-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search encrypted field (C Frank Wolfe 2015)
  2. Re: [WebDNA] Search encrypted field (Donovan Brooke 2015)
  3. Re: [WebDNA] Search encrypted field (C Frank Wolfe 2015)
  4. Re: [WebDNA] Search encrypted field (Dan Strong 2015)
  5. Re: [WebDNA] Search encrypted field (Stuart Tremain 2015)
  6. [WebDNA] Search encrypted field (C Frank Wolfe 2015)
--Apple-Mail=_C61195E5-59A1-4AE1-BF8D-0100109326CB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I don=E2=80=99t really need to search for )#$)(#$#($ but don=E2=80=99t = know how else to do it. I think Stuart=E2=80=99s idea of undecrypting to a table might be a good = answer. This site is on 4.5.1 and don=E2=80=99t think it does tables, but I = could do a temp db. I will try your [url] too, that would be the easiest =20 Thanks, 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 > On Aug 9, 2015, at 3:18 PM, Dan Strong wrote: >=20 > Do you mean you want to literally search for the string ")#$)(#$#($*" = (or whatever) or do you want to decrypt it first? >=20 > If the former, can you [url] the values in the database and then = search for [url])#$)(#$#($*[/url] >=20 > -Dan Strong > http://danstrong.com > http://sw.amphou.se > On Sun, Aug 9, 2015 at 6:15 PM, Stuart Tremain > wrote: > You may have to extract all the records into an unencrypted table and = then search the table. >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 > > On 10 Aug 2015, at 10:47, C Frank Wolfe > wrote: > > > > Hi, > > > > I think I=E2=80=99m making myself crazy trying to search for an = encrypted value. > > > > 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. > > > > Should I give up or is there some other way? > > > > Thanks, > > > > Frank > > > > 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 >=20 > --------------------------------------------------------- > 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 >=20 > --------------------------------------------------------- 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=_C61195E5-59A1-4AE1-BF8D-0100109326CB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I don=E2=80=99t really need to search = for )#$)(#$#($ but don=E2=80=99t know how else to do it.

I think Stuart=E2=80=99s idea of undecrypting to a table = might be a good answer.

This site is on 4.5.1 and = don=E2=80=99t think it does tables, but I could do a temp = db.

I will try your [url] too, = that would be the easiest   

Thanks,


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

On Aug 9, 2015, at 3:18 PM, Dan Strong <dan@danstrong.com> = wrote:

Do you mean you want to literally search for the = string ")#$)(#$#($*" (or whatever) or do you want to decrypt it = first?

If = the former, can you [url] the values in the database and then search for = [url])#$)(#$#($*[/url]


On Sun, Aug 9, 2015 at 6:15 = PM, Stuart Tremain <webdna@idfk.com.au> wrote:
You may have to = extract all the records into an unencrypted table and then search the = table.



Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au





> On 10 Aug 2015, at 10:47, C Frank Wolfe <frank@cwolfe.com> = wrote:
>
> Hi,
>
> I think I=E2=80=99m making myself crazy trying to search for an = encrypted value.
>
> 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.
>
> Should I give up or is there some other way?
>
> Thanks,
>
> Frank
>
> WebDNA = 4.5.1---------------------------------------------------------
> This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> 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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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=_C61195E5-59A1-4AE1-BF8D-0100109326CB-- C Frank Wolfe

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:

Multiple Stores and WebCatalog Prefs (1997) Require Value to be a Num (1998) Showif for mulitple variations (1997) Mac to UNIX (2000) Sendmail reply-to header? (2001) question: Eudora 3.1.1 (1997) WebDNA Writer Needed (1997) Great product and great job ! (1997) Not really WebCat (1997) Individual LineItemChangePassword files would be better ... (1999) PCS Frames (1997) CMSBuilder (2004) Nested tags count question (1997) WCS Newbie question (1997) WebCatalog2 Feature Feedback (1996) Date calculation problems (1997) WebCat2: Master Counter snippet (1997) Strange intermittent WebDNA problems Workaround (2008) [WebDNA] More wish-list requests implemented (2016) Multiple prices (1997)