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

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112093
interpreted = N
texte = --Apple-Mail-3444103C-256E-457A-A2B3-518735EA65AF Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You could always add an index number to the records. That would make it simp= le to sort in either direction. > On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen w= rote: >=20 > Hi Tom >=20 > That did the trick, thanks. >=20 > Wouldn=E2=80=99t it be logical if the reverse approach were achievable als= o 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 f= ields 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 Sorti= ng order be a candidate for the next WebDNA release. I find this very attrac= tive=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 i= n the db. >>=20 >> You would probably have to generate a table in reverse order and search t= hat 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 Reporti= ng: support@webdna.us >=20 > --------------------------------------------------------- This message is s= ent 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-3444103C-256E-457A-A2B3-518735EA65AF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
You could always add an index number t= o 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> wrot= e:

H= i Tom

That did the= trick, thanks.

Wo= uldn=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 tha= n one million rows and multiple fields associated and it would be a hassle t= o do that kind of work around and a waste of memory.

Christophe, are you aware of an easi= er solution or could the Reverse Sorting order be a candidate for the next W= ebDNA release. I find this very attractive=E2=80=A6 Any opinion from any oth= er on the List?

/P= alle



On 10/02/2015, at 15.52, Tom Duke <tom@revolutionaries.ie> wrote:

Palle,<= div class=3D"">
Hi - my recollection is t= hat you don't specify a sort order but do add "&rank=3Doff" to the searc= h string.  Then the data should display as written in the db.

You would probably have to g= enerate a table in reverse order and search that to get the reversed order.<= /div>

- Tom



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.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-3444103C-256E-457A-A2B3-518735EA65AF-- 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-3444103C-256E-457A-A2B3-518735EA65AF Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You could always add an index number to the records. That would make it simp= le to sort in either direction. > On Feb 10, 2015, at 12:43 PM, Palle Bo Nielsen w= rote: >=20 > Hi Tom >=20 > That did the trick, thanks. >=20 > Wouldn=E2=80=99t it be logical if the reverse approach were achievable als= o 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 f= ields 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 Sorti= ng order be a candidate for the next WebDNA release. I find this very attrac= tive=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 i= n the db. >>=20 >> You would probably have to generate a table in reverse order and search t= hat 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 Reporti= ng: support@webdna.us >=20 > --------------------------------------------------------- This message is s= ent 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-3444103C-256E-457A-A2B3-518735EA65AF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
You could always add an index number t= o 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> wrot= e:

H= i Tom

That did the= trick, thanks.

Wo= uldn=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 tha= n one million rows and multiple fields associated and it would be a hassle t= o do that kind of work around and a waste of memory.

Christophe, are you aware of an easi= er solution or could the Reverse Sorting order be a candidate for the next W= ebDNA release. I find this very attractive=E2=80=A6 Any opinion from any oth= er on the List?

/P= alle



On 10/02/2015, at 15.52, Tom Duke <tom@revolutionaries.ie> wrote:

Palle,<= div class=3D"">
Hi - my recollection is t= hat you don't specify a sort order but do add "&rank=3Doff" to the searc= h string.  Then the data should display as written in the db.

You would probably have to g= enerate a table in reverse order and search that to get the reversed order.<= /div>

- Tom



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.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-3444103C-256E-457A-A2B3-518735EA65AF-- Stephen Reiss

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:

problems with WebCat-Plugin () Using the sendmail command on CGate Pro (Unix) (2000) Help! WebCat2 bug (1997) Conveting Characters to Graphics (1997) WebCatalog dying in NT (1998) automating txt downloads for conversion to webcat db (2006) Initiating NewCart (1997) Press Release hit the NewsWire!!! (1997) Public Beta for WebCatalog 4.0 is Available (2000) Still having problems with Authen (1997) [ot] Bluetooth Phones That Allow SSH (2004) What am I missing (1997) Emailer again & again (1997) Trouble with Netscape (1998) Hiding the URL(was Cart ID Duplication) (2001) [WebDNA] DNA suffix (2008) Web Commerce thoughts and needs.. (1996) Auto Submit (2000) emailer w/F2 (1997) [SearchString] problem with [search] context (1997)