Re: Searching for a search solution

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31504
interpreted = N
texte = >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]] Your logic needs an adjustment ... :)Since [parent] won't have the value you want it to have until AFTER it appears inside the [founditems] context, this kind of circular thinking is impossible. Why don't you try this instead:[search db=Guestbook.db&neUniqueIDdatarq=[blank]] [founditems] [showif [UniqueID]=[parent]] This record's 'UniqueID' and 'parent' values are both [UniqueID].
[/showif] [/founditems] [/search] ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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)
>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]] Your logic needs an adjustment ... :)Since [parent] won't have the value you want it to have until AFTER it appears inside the [founditems] context, this kind of circular thinking is impossible. Why don't you try this instead:[search db=Guestbook.db&neUniqueIDdatarq=[blank]] [founditems] [showif [UniqueID]=[parent]] This record's 'UniqueID' and 'parent' values are both [UniqueID].
[/showif] [/founditems] [/search] ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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 Kenneth Grome

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:

[WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011) Browser Check for WebDNA compatability (1999) writing orders to a db (1997) math problems (2000) [ConvertChars] problem (1997) WriteFile and returns... (2000) suffix mapping for NT? (1997) WC Database Format (1997) Help! Strange happenings... (1997) Concatenating Form Variables (1998) Email within tmpl ? (1997) HomePage Caution (1997) problem: mail changed (1997) Location of Browser Info.txt file (1997) [Off Topic]Bay To Breakers (or WebCatalog Beats Intershop) (1998) Newbie Tax Question (1997) [isfile] ? (1997) Parse question (2005) Re[3]: Charting records by state (2000) Re:Email Problem (1997)