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" <[EMAIL PROTECTED]>
To: "Daniel Rusch" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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 - [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 )
>
_______________________________________________
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 )