This seems like a very odd situation, but Railo has stopped supporting column aliases by default - well it's the JDBC database driver I think... I'm not too good at all this back end java/database stuff.

But basically it all worked fine, now I've upgraded Railo, and things like this will throw an error.

view plain print about
1<cfquery name="aQuery" datasource="dsn">
2SELECT col1 AS colOne FROM table
3</cfquery>
4
5<cfdump var="#aQuery.colOne#">

I don't see why, this is such a common thing to do... Anyway, some one else has had the exact same problem not that long ago, and Google very kindly found me their blog post so I could fix it.

You just have to set "Alias Handling" to "true" for your datasources in the Railo Server Administrator. Then every thing works fine again.

I think the point of it is something to do with being able to grab the true column name and get hold of better metadata, but at the moment that's no use to me!

I really hope Adobe don't start doing this with Coldfusion!

Credit has to go to Anuj Gakhar for this fix: http://www.anujgakhar.com/2012/01/11/railo-mysql-and-column-aliases/

This entry was posted on February 17, 2012 at 2:32 PM and has received 98 views. There are currently 0 comments. Print this entry.