Comparing file names

[joethecool1]

I know how to bring up the contents of a folder and, I know how to fill a listbox by using a SQL statement. I don't know how to combine the two.

Here's the challenge. I'm trying to read file names from a listbox (which were filled after reading from a SQL field) and compare each one of them with entries from a file folder using the GetFiles object. The objective is to fill the listbox w/ file names that exist only in the folder and weed out the names that match in the SQL table. Ideas, anyone?

[ChrisWise]

Why not just do a nested loop?

some psuedo code (or how ever its spelt)

for i = 0  to sqlfilename in the sql field

    for x  = 0 to dirfilename in directory

          if sqlfilename(i) = dirfilename(x) then
                
                ListBox1.Items.Add(sqlfilename(i))
 
          end if

    next 

next

[joethecool1]

I did that, in a way. The problem was the program was writing each file name multiple times. I don't think I did it exactly the way you prescribed it, so I'll try it again to see if things turn out differently.

Oh, for future reference its 'pseudocode'.