Thanks Robby; the production machine is running Linux and so I had assumed it was *not* a case-problem but more related to my Cocoon and/or MySQL upgrade - and obviously I do not want to upgrade the production server until its running locally...
>>> "Robby Pelssers" <robby.pelss...@ciber.com> 09/14/09 10:20 AM >>> Not sure if this is important to mention but whenever you port a cocoon application from windows to unix... you'll bound to see exceptions.... like * FileNotFoundException * table not Found exception All this due to casesensitivity on unix systems... If this is related to this problem I don't know but it's worthwile checking the tablenames thoroughly and comparing them to your queries. Kind regards, Robby -----Original Message----- From: Derek Hohls [mailto:dho...@csir.co.za] Sent: Monday, September 14, 2009 9:03 AM To: users@cocoon.apache.org Subject: REPOST: Queries in Cocoon 2.1.11 not working with "AS"protocol? (From 2008-08-27 - I'm sure someone can check this error very easily?) I am in the process of porting my applications over from Windows to Linux as my development platform. I am now running Cocoon 2.1.11 and Mysql 5.0.67 (was 2.1.8 and 4.0.23) There is one issue I have encountered so far. When running a query of the form: SELECT foo AS bar from mytable The SQLTransformer gives back: <sq2:row> <sq2:foo>text</sq2:foo> </sq2:row> instead of: <sq2:row> <sq2:bar>text</sq2:bar> </sq2:row> (I have tested the same query using the MySQL Query Browser and it works as expected.) Does anyone know why this is and how I can fix it? Thanks Derek -- This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard. The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks Transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org For additional commands, e-mail: users-h...@cocoon.apache.org