Re: finding child records of child records of child records... with minimal code
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32719
interpreted = N
texte = fantastic! (Crosses fingers that stack memory or whatever it is called does not become aproblem as this db grows HUGE)-JohnJohn Peacock wrote:> Yes, that is a good job for recursion. You want to write an include> file that should include itself, with the parameter of the current ID.> This will generate the full tree of found records.>> In pseudo-code form (i.e. this is guaranteed to _not_ run):>> [Include file=includefile.inc&myID=[ID]] [!] look for top record [/!]>> and the include file would be:>> [Search db=file.db&parentID=[myID]]> [founditems]> [ReplaceFoundItems]flag=Y[/ReplaceFoundItems] (if you have 4.0)> [Include file=thisfile.inc&myID=[ID]]> [/founditems]> [/search]>> HTH>> John Peacock>>-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
fantastic! (Crosses fingers that stack memory or whatever it is called does not become aproblem as this db grows HUGE)-JohnJohn Peacock wrote:> Yes, that is a good job for recursion. You want to write an include> file that should include itself, with the parameter of the current ID.> This will generate the full tree of found records.>> In pseudo-code form (i.e. this is guaranteed to _not_ run):>> [Include file=includefile.inc&myID=[ID]] [!] look for top record [/!]>> and the include file would be:>> [Search db=file.db&parentID=[myID]]> [founditems]> [replacefounditems]flag=Y[/ReplaceFoundItems] (if you have 4.0)> [Include file=thisfile.inc&myID=[ID]]> [/founditems]> [/search]>> HTH>> John Peacock>>-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
John Butler
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:
Friendly , quick 'security' check, please (2003)
Exclamation point (1997)
not interpreting Q (2001)
WebDNA on Apache/Xserve (2003)
format and math on the fly (1998)
SET (1998)
WebCat2b15MacPlugin - showing [math] (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Sort & Shownext (1999)
Opinion: [input] should be called [output] ... (1997)
database problem (2003)
Cache problem (2002)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Username for Admin Group (1997)
eCommerce Idea Patented? (2002)
unable to launch acgi in WebCat (1997)
URGENT! ACGI Stopped!!!! (1997)
PCS Frames (1997)
Attn: Bug in GeneralStore example b15 (1997)
Associative lookup style? + bit more (1997)