Drew Wutka
dbatech at wolfwares.com
Thu Sep 23 11:39:43 CDT 2004
Sort of, the key difference is the 'spawning'. A loop just runs over and over. But each loop starts and ends, before the next one. In a recursive function, you are creating 'child' processes that have to start and finish before their parent can finish. For instance, take a function that runs through the files and folders on your machine: Call1 (to C:\ -- runs all files, and calls itself for all folders Call2 (to C:\WINNT\ -- same, but Call1 hasn't finished yet, because it called Call2) Call3 (to C:\WINNT\SYSTEM32\ -- now call 2 and 1 are still 'open', and this call is 'holding them') Call4 (to C:\WINNT\TEMP\) ...... ...... Call30 (to C:\WINNT\XYZ\ when this completes, all 'parent' calls can be closed, because it's the last folder to be hit, so now the function in Call1 can continue, which may produce another 'tree' of function calls) Does that make sense? Drew -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com]On Behalf Of Jon Tydda Sent: Thursday, September 23, 2004 10:24 AM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Empty folders I gotcha, looping in other words... Jon -----Original Message----- From: Drew Wutka [mailto:dbatech at wolfwares.com] Sent: 23 September 2004 16:18 To: Discussion of Hardware and Software issues Subject: RE: [dba-Tech] Empty folders LOL. Recursion is when you have a function call itself. Function SomeFunction() DoThis() DoThat() For Each Something In SomethingElse SomeFunction Next End function Not it will repeat itself until all elements have been used. Drew -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com]On Behalf Of Jon Tydda Sent: Tuesday, September 21, 2004 9:41 AM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Empty folders It's a little bit out of my league - I just hack vba in Excel... I hate it when you make me look words up... Hmmn, didn't help... "Recursive: An expression, such as a polynomial, each term of which is determined by application of a formula to preceding terms." Polynomial? eep, maths! Jon -----Original Message----- From: Drew Wutka [mailto:dbatech at wolfwares.com] Sent: 21 September 2004 15:37 To: Discussion of Hardware and Software issues Subject: RE: [dba-Tech] Empty folders right a little recursive code. Drew -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com]On Behalf Of Jon Tydda Sent: Tuesday, September 21, 2004 9:07 AM To: Dba-Tech (E-mail) Subject: [dba-Tech] Empty folders Hi all, does anyone know of a way to find empty folders in win2k? I'm re-ripping a lot of my cd collection, and some of the tracks/albums are being named more correctly as the online catalogs are more up to date than before, which is leaving me with a lot of empty folders. I have deleted the ones in the main tree, but as for going through all the artists folders and deleting the empty album names, that's going to be a pain... I was thinking that there has to be an easier way to do it than just looking... Jon The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com