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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112092
interpreted = N
texte = --Apple-Mail=_8625C258-34E2-4368-8D85-2BCAD04D0E18 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_8625C258-34E2-4368-8D85-2BCAD04D0E18 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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

= --Apple-Mail=_8625C258-34E2-4368-8D85-2BCAD04D0E18-- 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=_8625C258-34E2-4368-8D85-2BCAD04D0E18 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_8625C258-34E2-4368-8D85-2BCAD04D0E18 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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

= --Apple-Mail=_8625C258-34E2-4368-8D85-2BCAD04D0E18-- 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:

[Replace] really replaces? (2000) webcat page crashes MSIE 5 on mac (2000) Template cache problem with WC4 on Mac OS X (2000) variables in [addlineitem] (1998) WebCat2 several catalogs? (1997) Date or time comparisons have bugs ... (1998) Showif probably dumb question (1997) RE: Cart Template (1997) find with exceptions (1997) WCS Newbie question (1997) Multiple prices (1997) Attention eCommerce Sites (deadline 12/12) (1997) Number searching/formats (1998) OT: OSX calculator error (2004) math on date? (1997) WebCat2 - [format thousands] (1997) Out of the woodwork (2007) TRAINING videos - Prove IT. (1998) Setting up shop (1997) Superfilous Characters (1998)