[Zope-DB] Optional "Order By" clause

[Philip Kilner]

Hi List,

Stuck on syntax again!

Am trying to make an optional order-by clause, using "dtml-sqlgroup".

The following: -

<dtml-sqlgroup order by>
   <dtml-sqlvar OrderBy type="nb" optional>
</dtml-sqlgroup>

...is incorrect, but probably shows what I'm trying to do.

I've only previously used dtml-sqlgroup for "where" - can I even use it 
for order by? I don't know whether to interpret the absence of examples 
as a "no" to that, or to...an absence of examples!

If not, how should I address this?

All hints gratefully received!

-- 

Regards,

PhilK

Email: phil at xfr.co.uk / Voicemail & Facsimile: 07092 070518

"The lyf so short, the craft so long to learne" - Chaucer