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:

WebCat2b15MacPlugin - showing [math] (1997) Not really WebCat - need HTML Grider (1997) Very serious bug with the [protect] tag (2003) [WebDNA] [OT] WebDNA Wiki - need grammar check / (2009) remotely add + sign (1997) Text data with spaces in them... (1997) NT based White paper (2003) Permission denied? (2004) Upgrading old WebCat Database Files (1997) I'm new be kind (1997) PROBLEM (1997) Yet another db manager (2004) Size limit for tmpl editor ? (1997) Limiting user access to .tmpl files (1997) [HIDEIF] inside [FOUNDITEM] (1997) Storebuilder, Smith-Micro Tech Support (2000) Max Record length restated as maybe bug (1997) encryption in browser? (1998) [OT] (waaaay OT) further off topic than before (2004) Searching/sorting dates (1997)