Actually about the Spurious procedure iam happy with myelf that came up with this:
# Delete spurious cur.execute('''SELECT url FROM files''') data = cur.fetchall() for filename in path url = '/home/nikos/public_html/data/apps/' + filename urls.add( url ) for url in data: if url not in urls cur.execute('''DELETE FROM files WHERE url = %s''', (url,) ) Ddint try it yet though, need to anwer previous post's a) Is it correct that the first time i open os.listdir() as binary to grab the fileenames as bytestring and the 2nd normally to grab the filanems as unicode strings? -- http://mail.python.org/mailman/listinfo/python-list