Fred, Sorry, you are absolutely right, there was somewhere where the ORDER BY clause was hardcoded without the quotes.
I am making good progress with hsqldb/Melati, nearly there. The strict quoting requirement of hsqldb is unearthing a few small oversites in Melati, but I hope to have these ironed out soon. I would like to bundle hsqldb with Melati as the 'out of the box' db. I will let this list know when it is released. cheers timp On Saturday 25 May 2002 11:55, Fred Toussi wrote: > HSQLDB does support this feature. It seems all the column names in the > table definition are quoted, the same way as "id". In which case, you > should put the ORDER BY columns in double quotes and match the exact case > of the table definition: > > [SELECT "id" FROM "tableinfo" ORDER BY "displayorder", "name"] > > Fred _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
