Could be a case sensitivity issue. What's the OS of you, and of your host? On *nix systems table names are case sensitive.
-----Original Message----- From: Phillip Vector [mailto:[email protected]] Sent: Wednesday, March 24, 2010 2:03 PM To: cf-talk Subject: Differences between MySQLs? When I run this on my server.. SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' I get 6 results... This is a local Dev server I have set up. When i run it at my hosting company, I get 0 results for the same exact query. I go in and my external database program confirms the records are in there. The page works fine locally, but on the live site, it doesn't. Before I make a ticket, can anyone confirm perhaps a setting they heard of or some such that might be responsible or does anyone have any additional troubleshooting steps I may be missing? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
