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:

Help! WebCat2 bug (1997) WC2.0 Memory Requirements (1997) Combining search criteria (2000) WebCommerce: Folder organization ? (1997) too many nested tags ... (1997) Re:Variable Math (1998) unable to launch acgi in WebCat (1997) $Append for Users outside the ADMIN group (1997) Still Stumped on ShowNext...HELP! (1997) [WebDNA] advice on quoting a job (2009) search form problem.. (1997) Sorting problem (2002) WC1.6 to WC2 date formatting (1997) Word search (1997) Using WebCat for product info requests (1997) Weird Math and SV (1997) Requiring that certain fields be completed (1997) three cart questions (1997) .tmp files (2000) Include a big block of text (1997)