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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112097
interpreted = N
texte = --Apple-Mail=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Put another field in you db named SORTORDER which could be populated = AUTONUMBER=3DSORTORDER this will be populated from 1 - n Then just do a normal sort on SORTORDER Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 11 Feb 2015, at 2:49 am, Palle Bo Nielsen = wrote: >=20 > I agree. >=20 > 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. >=20 > The WebDNA core functionality would be very helpful here. >=20 > /Palle >=20 >=20 >> 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 > --------------------------------------------------------- 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=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Put another field in you db named SORTORDER which could be = populated AUTONUMBER=3DSORTORDER this will be populated from 1 - n

Then just do a normal = sort on SORTORDER


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 11 Feb 2015, at 2:49 am, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:

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

--------------------------------------------------------- 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=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536-- 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=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Put another field in you db named SORTORDER which could be populated = AUTONUMBER=3DSORTORDER this will be populated from 1 - n Then just do a normal sort on SORTORDER Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 11 Feb 2015, at 2:49 am, Palle Bo Nielsen = wrote: >=20 > I agree. >=20 > 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. >=20 > The WebDNA core functionality would be very helpful here. >=20 > /Palle >=20 >=20 >> 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 > --------------------------------------------------------- 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=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Put another field in you db named SORTORDER which could be = populated AUTONUMBER=3DSORTORDER this will be populated from 1 - n

Then just do a normal = sort on SORTORDER


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 11 Feb 2015, at 2:49 am, Palle Bo Nielsen <powerpalle@powerpalle.dk> wrote:

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

--------------------------------------------------------- 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=_4C6228AC-C41F-43FD-AFCD-E0AF608B3536-- Stuart Tremain

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:

protect acting looney?? (2003) Various Problems (1997) WebCat2 - many [carts] on one template page? (1997) AuthorizeNet Declines (2005) Compressed cookies? (2003) TCPConnect (2002) PCS Customer submissions ? (1997) Fun with dates (1997) Re:WebCatalog vidoes (was: Prices Dropped) (1998) Simple way to create unique SKU (1997) Date search and sendmail (1997) Duplicate Carts (2000) Misunderstanding?? (1997) AppleScript/.db (was:FTP to WebStar) (2001) I give up!! (1997) [format 40s]text[/format] doesn't work (1997) First n words (2000) Help name our technology! (1997) Fun with Dates - finally resolved but.... (1997) Summing fields (1997)