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

Reply via email to