No records at all. But on the local server, yes. Verified both databases are exactly alike.
On Wed, Mar 24, 2010 at 12:25 PM, Dorioo <[email protected]> wrote: > > any caching on your query? > > - Gabriel > > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector > <[email protected]> wrote: >> >> 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:332213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
