Any chance that the two databases are not identical? Perhaps the column type is not the same?
I imagine MySQL has something similar to Oracle: there are VARCHAR and CHAR (fixed width) columns. A query that would work fine against a varchar column would likely fail against a char column because of the spaces padded at the end of the values in the column. Just a thought..... Allen Phillip Vector wrote: > Both are windows, but I made sure anyway. Nope. That's not it. > > > > On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews > <[email protected]> wrote: > >> 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:332211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
