[Zope] Sorting 'in'

[Andy McKay]

Put an argument as sort_order and then your statement as:

SELECT * FROM Foo ORDER BY <dtml-var sort_order> ASC


--
  Andy McKay, Developer.
  ActiveState.
----- Original Message ----- 
From: "Yvonne Totty" <ytotty@atinucleus.com>
To: "Daniel Rusch" <drusch@globalcrossing.com>
Cc: <zope@zope.org>
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
> -------------------------
> 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 )
>