I'm with Mike on this one. The query is fine, as you know from running it on the DB server itself. CF does nothing more than pass through the query to the JDBC driver, but that query will present no difficulties. The only thing left that I can think of is that the datasource in CFAdmin isn't pointing to the right server and/or DB or something. Or maybe the user profile in the datasource config has no rights to see records in that table ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
