I have just upgraded a machine to Coldfusion MX and now none of my SELECT statements work. I can do and INSERT with no problem but when I do a SELECT statement I get 0 records.

I simplified the SQL statement to elliminate any problems with the stament but still cannot get it to find any records.

This statement find no recorsd but there are plently.

<cfquery name="MyFindQuery" datasource="MyDataSource">
SELECT text1 FROM ODBCTest
</cfquery>

Connecting to the same datasource I am able to insert records with the following statment:
<cfquery name="MyAddQuery" datasource="MyDataSource">
INSERT into ODBCTest (text1) VALUES ('#text1#')
</cfquery>

Any suggestions would be appreciated.

I am experiencing exactly the same problem. Could Inmagic respond to this?