Re: mySQL view coming up table not found?
It's OS X. The view was named properly, but I went back into the CFQUERY tag and found a field in the query that was not in the view. Fixing that fixed the error, though why that was causing it to say table not found I am not sure. ~| 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:326799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySQL view coming up table not found?
On Tue, Sep 29, 2009 at 1:01 PM, Rob Barthle r...@barthle.com wrote: 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 Is MySQL on Windows or Linux? On Linux MySQL table/view names are case sensitive because they correspond to files on the file system - that's caught me out once or twice (or maybe a few more times :) -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:326788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
mySQL view coming up table not found?
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