I should point out that in every other area of the site, the DB works perfectly. The only think I can think of is that the code is looped around 3 cfloops (I know.. It's not a good way to program it, but it's what I was able to come up with). Can CF Admin set a limit on the number of loops within themselves?
On Wed, Mar 24, 2010 at 12:38 PM, Andy Matthews <li...@commadelimited.com> 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:vec...@mostdeadlygame.com] > 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:332205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm