Originally Posted By: eriqjaffe
A couple of things I noticed...

 Code:
$recordset = DBGetRecordset("$objConn, $SQLQueryRS")

The arguments you pass to DBGetRecordset shouldn't be in quotes. Just:

 Code:
$recordset = DBGetRecordset($objConn,$SQLQueryRS)

...is sufficient.

On a SQL note, if you want to ingore duplicate email addresses, just add DISTINCT into your SELECT clause:

 Code:
"SELECT DISTINCT 'Email Address' FROM 'Person'"


Thankyou for your reply. The adding of DISTINCT into the SQLquery will save me alot of time finding and eliminating duplicates.

I did try your suggestion of removing the quotes and the script will error out with "ERROR : expected ')'!". Add the quotes back in and the script functions normally.