OTECTED]>
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
&
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)
so
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)
>
>
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 spande
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
> ~~~