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