As far as I know there is no requirement in MySQL for queries to be lowercase. I just ran one in all uppercase and it worked fine. There has to be something else causing this problem.
On Fri, Feb 26, 2010 at 1:57 AM, phil phil <arantxa...@gmail.com> wrote: > > Hello, > > I do need to migrate from Access to MySQL on a Windows and shared server > environment. > All existing queries (approx 2000) are failing because they are not > lowercased. > > Does anyone know of a script that would look into every files for the CFquery > tag and lowercase its content between? > > This is the only solution that comes to me but maybe there is a easier way? > > Thanks in advance for any feedbacks. > > Phil > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4