Re: [Zope] Sorting 'in'
Put an argument as sort_order and then your statement as: SELECT * FROM Foo ORDER BY 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 )
Re: [Zope] Sorting 'in'
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 )
Re: [Zope] Sorting 'in'
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 - [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 )
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 )
Re: [Zope] Sorting 'in'
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] Sorting 'in'
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?