aspose file tools
The moose likes Object Relational Mapping and the fly likes pestered by syntactical subtlties in HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "pestered by syntactical subtlties in HSQLDB" Watch "pestered by syntactical subtlties in HSQLDB" New topic
Author

pestered by syntactical subtlties in HSQLDB

Stuart Rogers
Ranch Hand

Joined: Oct 02, 2008
Posts: 140
purged for space
Stuart Rogers
Ranch Hand

Joined: Oct 02, 2008
Posts: 140
found it: problem is in the SECOND occurance of the CASE WHEN statement not having its calcRank mentioned in the SECOND GROUP BY block.

CASE CLOSED,

Thanks for reading,


Still-learning Steve
 
jQuery in Action, 2nd edition
 
subject: pestered by syntactical subtlties in HSQLDB