Re: [WebDNA] Search encrypted field

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112383
interpreted = N
texte = --001a11c3330e474663051ceac4cc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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] -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 the= n > 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 wrote: > > > > Hi, > > > > I think I=E2=80=99m making myself crazy trying to search for an encrypt= ed 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 > > --------------------------------------------------------- > 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 > --001a11c3330e474663051ceac4cc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Do you mean you want to literally search for the string &q= uot;)#$)(#$#(= $*" (or whatever) or do you want to decrypt it first?

<= div>If the fo= rmer, can you [url] the values in the database and then search for [url])#$)(#$#(= $*[/url]


On Sun, Aug 9, 2015 at 6:15 PM, Stuart Trema= in <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 encryp= ted value.
>
> If I want to find all records with=C2=A0 Fred, and fred is encrypted I= have to search for [search db=3Dsomedab.db&eqNAMEdata=3D )#$)(#$#($*]<= br> > 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---------------------------------------------------------<= br> > This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us<= /a>>.
> To unsubscribe, E-mail to: <
talk-leave@webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting:
support@webdna.us<= /a>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <
talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

--001a11c3330e474663051ceac4cc-- 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)
--001a11c3330e474663051ceac4cc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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] -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 the= n > 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 wrote: > > > > Hi, > > > > I think I=E2=80=99m making myself crazy trying to search for an encrypt= ed 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 > > --------------------------------------------------------- > 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 > --001a11c3330e474663051ceac4cc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Do you mean you want to literally search for the string &q= uot;)#$)(#$#(= $*" (or whatever) or do you want to decrypt it first?

<= div>If the fo= rmer, can you [url] the values in the database and then search for [url])#$)(#$#(= $*[/url]

On Sun, Aug 9, 2015 at 6:15 PM, Stuart Trema= in <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 encryp= ted value.
>
> If I want to find all records with=C2=A0 Fred, and fred is encrypted I= have to search for [search db=3Dsomedab.db&eqNAMEdata=3D )#$)(#$#($*]<= br> > 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---------------------------------------------------------<= br> > This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us<= /a>>.
> To unsubscribe, E-mail to: <
talk-leave@webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting:
support@webdna.us<= /a>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <
talk@webdna.us&g= t;.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

--001a11c3330e474663051ceac4cc-- Dan Strong

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 'Users.db' files not possible (1997) How do you hide [math]stuff[/math] (1997) [Fwd: can we get string variables?] (1998) Hiding the URL(was Cart ID Duplication) (2001) decrypt trouble (2006) HEADER AND FOOTER (1997) Form based Redirect (2001) RE: [WebDNA] trouble with memory (2014) WebCat2 Append problem (B14Macacgi) (1997) Why does setheader provide a db= parameter? (2005) European dates (1998) Re:quit command on NT (1997) WebCat2: multiple currency support (1997) Review comparison by PC Magazine: Open for On-line Business (1997) multiple price line in formula.db (2004) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) 404 error page issue (2006) One other big addition... (1997) Log-in Scheme (2003) more [sendmail] woes.. (2000)