File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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
 
 
subject: pestered by syntactical subtlties in HSQLDB