I'm writing a script in ASP to filter emails by certain criteria. I have my main registration database with all the user details.

First I create a new table on the fly and insert the name and emailaddress of the person to the new table via an INSERT SELECT query with a WHERE clause.

I immediately query the new table using count(*) to get the total number of records to see how many emails I have, but I always get the number 32767. But when I go in to MySQL and query the table directly I get a total of 820090. ?!?!?!?

So I'm thinking that maybe the query is sent to MySQL and ASP closes the DB connection before MySQL is done with whatever it's doing. Then when I run count(*), it's capturing a total while MySQL is doing it's thing.

Anybody have any insight on this? Thanks in advanced.