Re: Searching for a search solution

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31490
interpreted = N
texte = How are you getting the value for the parent variable?You might have to embed your search like this... [search db=Guestbook.db&neUniqueIDdata=[blank]] [founditems] [search db=Guestbook.db&eqUniqueIDdatarq=[parent]] [founditems][stuff][/founditems] [/search] [/founditems] [/search] Hope that helps... Jason Sofonia:: Digital Frontier :: jason@digitalfrontier.com :: on 05.05.00 12:36 pm, Andy Mowrey at mowrey@inpgh.com 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¬Fou > nd=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? > ------------------------------------------------------------- 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)
How are you getting the value for the parent variable?You might have to embed your search like this... [search db=Guestbook.db&neUniqueIDdata=[blank]] [founditems] [search db=Guestbook.db&eqUniqueIDdatarq=[parent]] [founditems][stuff][/founditems] [/search] [/founditems] [/search] Hope that helps... Jason Sofonia:: Digital Frontier :: jason@digitalfrontier.com :: on 05.05.00 12:36 pm, Andy Mowrey at mowrey@inpgh.com 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¬Fou > nd=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? > ------------------------------------------------------------- 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 Jason Sofonia

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:

customer.db and forms (1999) Try not to laugh (2007) Loosing Quantity (2000) WCS Newbie question (1997) Free Utility (2003) Sample Tearoom Search Error - Solved! (1997) PC Cookie Problem? (2003) simple forum/bboard (2004) Dark Horse Comics success story (1997) WC2b15 File Corruption (1997) database search help (2003) Upload Maximum (2003) Is there a max number of fields? (1998) won't serve .tpl (2000) Multiple prices (1997) Simple counter - how? (1997) WebCat2 several catalogs? (1997) [ot] html question (2000) WebCat2 - Getting to the browser's username/password data (1997) Extended [ConvertChars] (1997)