Hi Yvonne, You could use Zieve, (http://www.zope.org/Members/sspickle/Zieve) or you could render the 'order by' part of your clause from a variable in the name space, or possibly the REQUEST itself. There was also a patch submitting at one point that allows variable (and I think multiple) sort keys... -steve
"Yvonne" == Yvonne Totty <ytotty@atinucleus.com> writes:
Yvonne> Yes, that is what I am doing, however was wanting to not Yvonne> have to write several Z SQL Methods. 8) Yvonne> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Yvonne Totty Yvonne> Database Engineer ------------------------- Wolverine: You Yvonne> actually go outside in these things? Cyclops: Well, what Yvonne> 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? >> > >> Yvonne> _______________________________________________ Zope Yvonne> maillist - Zope@zope.org Yvonne> http://lists.zope.org/mailman/listinfo/zope ** No cross Yvonne> posts or HTML encoding! ** (Related lists - Yvonne> http://lists.zope.org/mailman/listinfo/zope-announce Yvonne> http://lists.zope.org/mailman/listinfo/zope-dev )