I have a database with 2 tables.<BR>There are image names in both tables.<BR>The actual files are in a folder. I need to detect if the querystring (filename) is in either of these tables. <BR><BR><% pics.Source = "SELECT * FROM car where filename = '" + Replace(image__MMColParam, "'", "''") + "'" %><BR><BR><% if autos.BOF or autos.EOF then %><BR>Ok to Remove!<BR><% else %>This file is currently being used!<BR><% end if %><BR><% if pics.BOF or pics.EOF then %>Ok to Remove!(2)<% else %>This file is currently being used!(2)<% end if %><BR><BR>The image name will appear in one table or neither. However, it should say this, and it wont detect the image name in the 2nd table... why is this?