You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Derek Hohls <dh...@csir.co.za> on 2009/08/27 10:32:21 UTC

Queries not working with "AS" protocol?

I am in the process of moving 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-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org