hi yvonne, in your zsql method, you can order by several variables in the same method call. so you can do it all in one method. ciao! greg. Gregory Haley Venaca.com Yvonne Totty wrote:
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 )