[Zope] Sorting 'in'

Steve Spicklemire steve@spvi.com
Mon, 6 Nov 2000 13:27:36 -0500 (EST)


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 )