jQuery in Action, 3rd edition
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 Head First Android this week in the Android 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
 
wood burning stoves
 
subject: pestered by syntactical subtlties in HSQLDB
 
It's not a secret anymore!