There is no difference: we successfully query SQL Server views all the time in several of our apps. Have you checked the permissions? Could it be that the View doesn't allow the CF service user to SELECT data?
---------------------------------------- From: "Phillip Vector" <vec...@mostdeadlygame.com> Sent: Thursday, May 19, 2011 10:12 AM To: "cf-talk" <cf-talk@houseoffusion.com> Subject: Re: Recordcount not working???? > 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:344677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm