No. The live database table is exactly the same as the dev table (it was copied over directly).
I'm just going to ask support and perhaps they will be able to help. Thanks anyway. :) On Wed, Mar 24, 2010 at 1:54 PM, G Allen R Souliere <[email protected]> wrote: > > 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:332215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
