Re: Searching for a search solution

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31492
interpreted = N
texte = You need to use nested queries to get what you want. Try this:[search db=Guestbook.db&neUniqueIDdatarq=[BLANK]] [founditems] [search db=Guestbook.db&eqParentdatarq=[UniqueID]] [founditems] Got One: [UniqueID] = [parent] [/founditems] [/search] [/founditems] [/search]HTHJohn PeacockAndy Mowrey wrote: > > TgIF, > > I'm trying to to do a search that's looking for identical strings in different fields of the same database, [UniqueID] and [parent]. This is what I have, and it's not turning up anything: > > [search db=Guestbook.db&eqUniqueIDdatarq=[parent]] > > I've tried this: > [search db=Guestbook.db&eqUniqueIDdatarq=[LOOKUP db=Guestbook.db&value=[parent]&lookInField=parent&returnField=fieldName¬Found=xx]] > > This doesn't work either. I know for a fact their is one record (with more on the way) that has UniqueID and parent equaling the same thing but need a way to pull it up. Any ideas? > > WebCat 2.1.3 on Web* > > Tia, > > Andy Mowrey > Web & Systems Manager > In Pittsburgh Weekly > http://www.inpgh.com > (412) 488-1212 x285 > mowrey@inpgh.com > > ------------------------------------------------------------- > 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:

    
  1. Re: Searching for a search solution (Kenneth Grome 2000)
  2. Re: Searching for a search solution (John Peacock 2000)
  3. Re: Searching for a search solution (Jason Sofonia 2000)
  4. Searching for a search solution (Andy Mowrey 2000)
You need to use nested queries to get what you want. Try this:[search db=Guestbook.db&neUniqueIDdatarq=[BLANK]] [founditems] [search db=Guestbook.db&eqParentdatarq=[UniqueID]] [founditems] Got One: [UniqueID] = [parent] [/founditems] [/search] [/founditems] [/search]HTHJohn PeacockAndy Mowrey wrote: > > TgIF, > > I'm trying to to do a search that's looking for identical strings in different fields of the same database, [UniqueID] and [parent]. This is what I have, and it's not turning up anything: > > [search db=Guestbook.db&eqUniqueIDdatarq=[parent]] > > I've tried this: > [search db=Guestbook.db&eqUniqueIDdatarq=[LOOKUP db=Guestbook.db&value=[parent]&lookInField=parent&returnField=fieldName¬Found=xx]] > > This doesn't work either. I know for a fact their is one record (with more on the way) that has UniqueID and parent equaling the same thing but need a way to pull it up. Any ideas? > > WebCat 2.1.3 on Web* > > Tia, > > Andy Mowrey > Web & Systems Manager > In Pittsburgh Weekly > http://www.inpgh.com > (412) 488-1212 x285 > mowrey@inpgh.com > > ------------------------------------------------------------- > 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 John Peacock

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:

Re:Hideif / Showif (1998) Newbie problem blah blah blah (1997) Multiple security dbs (1997) RE: Formulas.db + Users.db (1997) wild question (1998) Roundup function? (1997) [WebDNA] Mondy morn... [date] question (2009) Not really WebCat (1997) [WebDNA] WebDNA is not parsing CSS file (2010) Dreamweaver (2002) Not really WebCat (1997) Formating found categories (1997) Dealer Locator (2008) [LOOKUP] (1997) [WebDNA] TCPConnect/cURL alternative for windows? (2010) #$%@! formulas (1998) Beta 18 (1997) WebCat b15 Mac plug-in (1997) Search design (1997) RE: [WebDNA] FastCGI version confusion (2011)