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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 133
purged for space
Stuart Rogers
Ranch Hand

Joined: Oct 02, 2008
Posts: 133
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: pestered by syntactical subtlties in HSQLDB
 
Similar Threads
bean classes from an XML file with a lot of nested tags, using XSTREAM
Map Problem
Test for equality of two objects
Printing records in two or more columns
Multiple repeat insert