Re: [WebDNA] Sort Direction matches the written to file order

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112094
interpreted = N
texte = --Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I agree. But some of my index mechanism are not chronologic and as such can not = be used. Like for instance [cart] which sometimes ads a character or two = extra. The WebDNA core functionality would be very helpful here. /Palle > On 10/02/2015, at 16.45, Stephen Reiss wrote: >=20 > You could always add an index number to the records. That would make = it simple to sort in either direction. >=20 >=20 >=20 > On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen = > wrote: >=20 >> Hi Tom >>=20 >> That did the trick, thanks. >>=20 >> Wouldn=E2=80=99t it be logical if the reverse approach were = achievable also in stead of doing a TABLE and then REVERSE the output? >>=20 >> I often work with databases with more than one million rows and = multiple fields associated and it would be a hassle to do that kind of = work around and a waste of memory. >>=20 >> Christophe, are you aware of an easier solution or could the Reverse = Sorting order be a candidate for the next WebDNA release. I find this = very attractive=E2=80=A6 Any opinion from any other on the List? >>=20 >> /Palle >>=20 >>=20 >>=20 >>> On 10/02/2015, at 15.52, Tom Duke > wrote: >>>=20 >>> Palle, >>>=20 >>> Hi - my recollection is that you don't specify a sort order but do = add "&rank=3Doff" to the search string. Then the data should display as = written in the db. >>>=20 >>> You would probably have to generate a table in reverse order and = search that to get the reversed order. >>>=20 >>> - Tom >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I agree.

But some of my index mechanism are not = chronologic and as such can not be used. Like for instance [cart] which = sometimes ads a character or two extra.

The WebDNA core functionality would be = very helpful here.

/Palle


On = 10/02/2015, at 16.45, Stephen Reiss <wineguy@mac.com> wrote:

You could always = add an index number to the records. That would make it simple to sort in = either direction.



On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen = <powerpalle@powerpalle.dk> wrote:

Hi = Tom

That did = the trick, thanks.

Wouldn=E2=80=99t it be logical if the reverse approach were = achievable also in stead of doing a TABLE and then REVERSE the = output?

I = often work with databases with more than one million rows and multiple = fields associated and it would be a hassle to do that kind of work = around and a waste of memory.

Christophe, are you aware of an easier = solution or could the Reverse Sorting order be a candidate for the next = WebDNA release. I find this very attractive=E2=80=A6 Any opinion from = any other on the List?

/Palle



On 10/02/2015, at 15.52, Tom = Duke <tom@revolutionaries.ie> wrote:

Palle,

Hi = - my recollection is that you don't specify a sort order but do add = "&rank=3Doff" to the search string.  Then the data should = display as written in the db.

You would probably have to generate a = table in reverse order and search that to get the reversed = order.

- = Tom



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Sort Direction matches the written to file order (christophe.billiottet@webdna.us 2015)
  2. Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
  3. Re: [WebDNA] Sort Direction matches the written to file order (Stuart Tremain 2015)
  4. Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
  5. Re: [WebDNA] Sort Direction matches the written to file order (Stuart Tremain 2015)
  6. Re: [WebDNA] Sort Direction matches the written to file order (Kenneth Grome 2015)
  7. Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
  8. Re: [WebDNA] Sort Direction matches the written to file order (Stephen Reiss 2015)
  9. Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
  10. Re: [WebDNA] Sort Direction matches the written to file order (Tom Duke 2015)
  11. [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
--Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I agree. But some of my index mechanism are not chronologic and as such can not = be used. Like for instance [cart] which sometimes ads a character or two = extra. The WebDNA core functionality would be very helpful here. /Palle > On 10/02/2015, at 16.45, Stephen Reiss wrote: >=20 > You could always add an index number to the records. That would make = it simple to sort in either direction. >=20 >=20 >=20 > On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen = > wrote: >=20 >> Hi Tom >>=20 >> That did the trick, thanks. >>=20 >> Wouldn=E2=80=99t it be logical if the reverse approach were = achievable also in stead of doing a TABLE and then REVERSE the output? >>=20 >> I often work with databases with more than one million rows and = multiple fields associated and it would be a hassle to do that kind of = work around and a waste of memory. >>=20 >> Christophe, are you aware of an easier solution or could the Reverse = Sorting order be a candidate for the next WebDNA release. I find this = very attractive=E2=80=A6 Any opinion from any other on the List? >>=20 >> /Palle >>=20 >>=20 >>=20 >>> On 10/02/2015, at 15.52, Tom Duke > wrote: >>>=20 >>> Palle, >>>=20 >>> Hi - my recollection is that you don't specify a sort order but do = add "&rank=3Doff" to the search string. Then the data should display as = written in the db. >>>=20 >>> You would probably have to generate a table in reverse order and = search that to get the reversed order. >>>=20 >>> - Tom >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I agree.

But some of my index mechanism are not = chronologic and as such can not be used. Like for instance [cart] which = sometimes ads a character or two extra.

The WebDNA core functionality would be = very helpful here.

/Palle


On = 10/02/2015, at 16.45, Stephen Reiss <wineguy@mac.com> wrote:

You could always = add an index number to the records. That would make it simple to sort in = either direction.



On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen = <powerpalle@powerpalle.dk> wrote:

Hi = Tom

That did = the trick, thanks.

Wouldn=E2=80=99t it be logical if the reverse approach were = achievable also in stead of doing a TABLE and then REVERSE the = output?

I = often work with databases with more than one million rows and multiple = fields associated and it would be a hassle to do that kind of work = around and a waste of memory.

Christophe, are you aware of an easier = solution or could the Reverse Sorting order be a candidate for the next = WebDNA release. I find this very attractive=E2=80=A6 Any opinion from = any other on the List?

/Palle



On 10/02/2015, at 15.52, Tom = Duke <tom@revolutionaries.ie> wrote:

Palle,

Hi = - my recollection is that you don't specify a sort order but do add = "&rank=3Doff" to the search string.  Then the data should = display as written in the db.

You would probably have to generate a = table in reverse order and search that to get the reversed = order.

- = Tom



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
= --Apple-Mail=_C9D8C9AF-1970-44C1-8B6B-DA2B8AAFC480-- Palle Bo Nielsen

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

CSS in HTML emails? (2003) Re2: frames & carts (1997) taxTotal, grandTotal (1997) re: Default contains WEBDNA (1998) Relevancy Rating (1998) PSC recommends what date format yr 2000??? (1997) [LOOKUP] (1997) WCS Newbie question (1997) Emailer setup (1997) Re:Emailer Set Up (1997) [OT] CSS div/span (2004) WebCat2 beta 11 - new prefs ... (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Passwords, Subscription, DBs, oh my! (2000) Multihoming and webcat (1998) Multiple fields on 1 input (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) WebDNA Writer Needed (1997) Shopping problems with 2.1b3 acgi (1997) RE: URL too Long? (1997)