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 <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED]
    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 )



_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
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 )

Reply via email to