Thanks Tim, We have made a big effort to extend support for SQL and JDBC standards as well as improvements in other areas so that HSQLDB can be used with other products with fewer problems. Please let us know about any other potential issues.
Fred ----- Original Message ----- From: "Tim Pizey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 25 May 2002 17:58 Subject: Re: [Hsqldb-developers] ORDER BY bug 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 _______________________________________________________________ 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
