What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Errant Email. (1998) Requiring that certain fields be completed (1997) WebCat editing, SiteGuard & SiteEdit (1997) Math Function (1997) [WebDNA] Processor Maxing out (2010) syntax question, not in online refernce (1997) javascript problem copying values (2000) Bill To - Ship To Information display (1997) Banners and sort of random display (1997) Logging purchases (1997) [ConvertChars] problem (1997) What am I missing (1997) Emailer problems addition (1999) sort (2000) WebCat2 Append problem (B14Macacgi) (1997) Pithy questions on webcommerce & siteedit (1997) Still More on EudoraPro Email (1998) RE: creating writefile data from a nested search (1997) question: back button prevention (1997) CSV import suggestions (2007)