Re: [WebDNA] Comparing fields in a search

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104468
interpreted = N
texte = --000e0cd1a3f00f0366047d13d507 Content-Type: text/plain; charset=ISO-8859-1 Thanks Ken. I knew there had to be a simple answer (one that I should have been able to come up with myself ;). Tana On Wed, Jan 13, 2010 at 12:47 PM, Kenneth Grome wrote: > [search db=xxx.db&neskudatarq=[blank]] > [founditems] > [showif [url][field1][/url]=[url][field2][/url]] > field1 and field2 in record [sku] are the same
> [/showif] > ]/founditems] > [/search] > > Sincerely, > Kenneth Grome > www.KenGrome.com > > > > > > > > > Is there a way to compare two fields in one search context? For example, > > I'm searching for all items that contain an identical field1 and field2. > > Currently, I'm wrapping a search within a search to compare but I'm > > wondering if I'm missing an easier, more efficient method. > > > > Thanks! > > > > Tana > > > > --------------------------------------------------------- > 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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 > --000e0cd1a3f00f0366047d13d507 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Ken.=A0 I knew there had to be a simple answer (one that I should ha= ve been able to come up with myself ;).

Tana

On Wed, Jan 13, 2010 at 12:47 PM, Kenneth Grome <kengrome@gmail.com> wrote:
[search db=3Dxxx.= db&neskudatarq=3D[blank]]
[founditems]
[showif [url][field1][/url]=3D[url][field2][/url]]
field1 and field2 in record [sku] are the same<br>
[/showif]
]/founditems]
[/search]

Sincerely,
Kenneth Grome
www.KenGrome.com<= br>







> Is there a way to compare two fields in one search context? =A0For exa= mple,
> I'm searching for all items that contain an identical field1 and f= ield2.
> Currently, I'm wrapping a search within a search to compare but I&= #39;m
> wondering if I'm missing an easier, more efficient method.
>
> Thanks!
>
> Tana
>

-----------------------------= ----------------------------
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
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288

--000e0cd1a3f00f0366047d13d507-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Comparing fields in a search (Tana Adams 2010)
  2. Re: [WebDNA] Comparing fields in a search (Kenneth Grome 2010)
  3. [WebDNA] Comparing fields in a search (Tana Adams 2010)
--000e0cd1a3f00f0366047d13d507 Content-Type: text/plain; charset=ISO-8859-1 Thanks Ken. I knew there had to be a simple answer (one that I should have been able to come up with myself ;). Tana On Wed, Jan 13, 2010 at 12:47 PM, Kenneth Grome wrote: > [search db=xxx.db&neskudatarq=[blank]] > [founditems] > [showif [url][field1][/url]=[url][field2][/url]] > field1 and field2 in record [sku] are the same
> [/showif] > ]/founditems] > [/search] > > Sincerely, > Kenneth Grome > www.KenGrome.com > > > > > > > > > Is there a way to compare two fields in one search context? For example, > > I'm searching for all items that contain an identical field1 and field2. > > Currently, I'm wrapping a search within a search to compare but I'm > > wondering if I'm missing an easier, more efficient method. > > > > Thanks! > > > > Tana > > > > --------------------------------------------------------- > 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 > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 > --000e0cd1a3f00f0366047d13d507 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Ken.=A0 I knew there had to be a simple answer (one that I should ha= ve been able to come up with myself ;).

Tana

On Wed, Jan 13, 2010 at 12:47 PM, Kenneth Grome <kengrome@gmail.com> wrote:
[search db=3Dxxx.= db&neskudatarq=3D[blank]]
[founditems]
[showif [url][field1][/url]=3D[url][field2][/url]]
field1 and field2 in record [sku] are the same<br>
[/showif]
]/founditems]
[/search]

Sincerely,
Kenneth Grome
www.KenGrome.com<= br>







> Is there a way to compare two fields in one search context? =A0For exa= mple,
> I'm searching for all items that contain an identical field1 and f= ield2.
> Currently, I'm wrapping a search within a search to compare but I&= #39;m
> wondering if I'm missing an easier, more efficient method.
>
> Thanks!
>
> Tana
>

-----------------------------= ----------------------------
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
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288

--000e0cd1a3f00f0366047d13d507-- Tana Adams

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:

your mail (2000) [BoldWords] WebCat.acgib15Mac (1997) Further tests with the infamous shipCost (1997) protect tag not working (1998) date pref (1999) Version 2.1.3 changes ... (1998) New public beta available (1997) security (1997) Omnihttpd server on Win98 : Who knows how to configure it? (1999) [referrer] tag (1997) RE: OK, here goes... (1997) my price won't move (1997) Hosts who have upgraded to v5.0? (2003) search function (2005) How does WebCatalog search the database? (1997) Unexpected error (1997) docs for WebCatalog2 (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Date Bug (1998) Limiting user access to .tmpl files (1997)