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:

Summary search -- speed (1997) Text data with spaces in them... (1997) Authenticate Checker - different versions ?? (1998) Hosts who have upgraded to v5.0? (2003) Help name our technology! I found it (1997) PCS Frames (1997) PIXO Support (1997) Re:Searching for ALL / empty form field (1997) unable to launch acgi in WebCat (1997) Hosting Service (1998) 2.0Beta Command Ref (can't find this instruction) (1997) WebCatalog for Postcards ? (1997) pop up menu's (1998) WebCat2 - [format thousands] (1997) return missing item (was:WebCat Sales) (1997) There's a bug in the math context ... (1997) [CART] (1997) Developer Edition (2003) spaces in [texta] (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997)