> Are you under CFMX? Try to remove dbtype="ODBC" > This is not valid anymore:
Thanks for the tip. Eliminated, but still not working. I changed the query to point to a table and that works fine. It's looking up a view that it does this. I can't find anywhere on the interwebs where the is a difference between querying a view or a table in coldfusion. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm