Put an argument as sort_order and then your statement as: SELECT * FROM Foo ORDER BY <dtml-var sort_order> ASC -- Andy McKay, Developer. ActiveState. ----- Original Message ----- From: "Yvonne Totty" <ytotty@atinucleus.com> To: "Daniel Rusch" <drusch@globalcrossing.com> Cc: <zope@zope.org> Sent: Monday, November 06, 2000 8:17 AM Subject: RE: [Zope] Sorting 'in'
Yes, that is what I am doing, however was wanting to not have to write several Z SQL Methods. 8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer ------------------------- Wolverine: You actually go outside in these things? Cyclops: Well, what would you prefer? Yellow spandex?
If it's a database query sorting with sql first. i.e. ORDER BY X,Y
HTH
Dan
Yvonne Totty wrote:
Hi!
I need a query sorted by 2-3 different attributes. The 'in' sort only lets me do it by one. Is there a way to get around it?
TIA -y ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Database Engineer ------------------------- Wolverine: You actually go outside in these things? Cyclops: Well, what would you prefer? Yellow spandex?
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )