Make sure the code cfquery is actually calling the test dsn and not the live dsn.