Preface: I am experienced in MS SQL, but have begun (out of need) to port over applicatons to MySQL 5.
I have a simple view that I created using Navicat and saved. When I try to call the view with CFQUERY though, I get the following error: "Table 'bettybarthle_com.vListingsSale' doesn't exist" I double checked the spelling of the view name, it's correct. And on the page that calls this page, I call to a view and it works fine. And I can run the view fine from Navicat Any idea what may be going on? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
