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:

The Form authentication trick (2000) redirect with frames (1997) WebCat2b12 - nesting [tags] (1997) [WebDNA] search command problem (2009) apache on OSX (2000) Problem with pull down menu (1998) Banners (1997) Problems with shopping cart (1997) UnitShipCost Slight Return (2003) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Ports? (2002) Pull Down Search (2000) Not really WebCat (1997) OT: Urgent help with Windows and Javascript (2003) Line Endings (2007) return missing item (was:WebCat Sales) (1997) Encryption of E-mail (1998) How far do [showif]s go? (1997) How Many SKU's is enough? (1997) Bug or syntax error on my part? (1997)