Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Column name too wide

 
Mel Calvin
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
If I have a sql query that looks like this:

and result is returned as a collection of dynabeans. When I want to retrieve the data from the updated_date column I need to write like this:

with the "column name" truncated down to 32 chars, else it won't work. Now, this isn't an elegant solution. Anyone have better solution for this?

Thanks.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could you not alias the columns in your result set? i.e.:
 
Mel Calvin
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Aah.. I knew there was a SQL-side solution to this. My SQL skills are limited, thanks for the help!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic