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?
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?
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?
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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 )
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 )
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 )
participants (5)
-
Andy McKay -
Daniel Rusch -
Gregory Haley -
Steve Spicklemire -
Yvonne Totty