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

This WebDNA talk-list message is from

2015

It keeps the original formatting. numero = 112100
interpreted = N
texte = --Apple-Mail=_56B4B39B-ABD8-4A5A-82F2-B854C98DB0C3Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Hi StuartThanks - all though I am aware of the Autonumber functionality, it only =works when a new row is written to DB and I have have several DB=E2=80=99s= without any chronological index=E2=80=99es unfortunately. I could =develop a mechanism which populates all my DB=E2=80=99s (one by one) =which populates them using the Autonumber function, but it would be a =hassle an take a lot of time to process. A build in =E2=80=98Reverse=3DTru=e=E2=80=99 would be a perfect solution.=20Is still see the need of a WebDNA Function which can help here...Palle...:> Wouldn=E2=80=99t it be logical if the reverse approach were achievable> also instead of doing a TABLE and then REVERSE the output?Kenneth Grome...:Absolutely, and this is something I have wished for forever.Something as simple as "reverse=3DT" to be interpreted only when"rank=3Doff" is used might be an easy way to do it.Christophe. What is your view on this challenge/possibility?/Palle> On 10/02/2015, at 23.24, Stuart Tremain wrote:>=20> Put another field in you db named SORTORDER which could be populated =AUTONUMBER=3DSORTORDER this will be populated from 1 - n>=20> Then just do a normal sort on SORTORDER>=20>=20> Kind regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au >=20>=20>=20>=20>=20>> 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 > --------------------------------------------------------- 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=_56B4B39B-ABD8-4A5A-82F2-B854C98DB0C3Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8

Hi Stuart

Thanks - all though I am aware of the =Autonumber functionality, it only works when a new row is written to DB =and I have have several DB=E2=80=99s without any chronological =index=E2=80=99es unfortunately. I could develop a mechanism which =populates all my DB=E2=80=99s (one by one) which populates them using =the Autonumber function, but it would be a hassle an take a lot of time =to process. A build in =E2=80=98Reverse=3DTrue=E2=80=99 would be a =perfect solution.

Is still see the need of a WebDNA Function which can help =here...

Palle...:

Wouldn=E2=80=99t it be =logical if the reverse approach were achievable
also =instead of doing a TABLE and then REVERSE the output?

Kenneth =Grome...:
Absolutely, and this is something I have wished =for forever.
Something as simple as "reverse=3DT" to be =interpreted only when
"rank=3Doff" is used might be an =easy way to do it.

Christophe. What is your =view on this challenge/possibility?

/Palle

On =10/02/2015, at 23.24, Stuart Tremain <webdna@idfk.com.au> =wrote:

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 <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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
=--Apple-Mail=_56B4B39B-ABD8-4A5A-82F2-B854C98DB0C3-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Sort Direction matches the written to file order (christophe.billiottet@webdna.us 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Stuart Tremain 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Stuart Tremain 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Kenneth Grome 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Stephen Reiss 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)
Re: [WebDNA] Sort Direction matches the written to file order (Tom Duke 2015)
[WebDNA] Sort Direction matches the written to file order (Palle Bo Nielsen 2015)

--Apple-Mail=_56B4B39B-ABD8-4A5A-82F2-B854C98DB0C3Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Hi StuartThanks - all though I am aware of the Autonumber functionality, it only =works when a new row is written to DB and I have have several DB=E2=80=99s= without any chronological index=E2=80=99es unfortunately. I could =develop a mechanism which populates all my DB=E2=80=99s (one by one) =which populates them using the Autonumber function, but it would be a =hassle an take a lot of time to process. A build in =E2=80=98Reverse=3DTru=e=E2=80=99 would be a perfect solution.=20Is still see the need of a WebDNA Function which can help here...Palle...:> Wouldn=E2=80=99t it be logical if the reverse approach were achievable> also instead of doing a TABLE and then REVERSE the output?Kenneth Grome...:Absolutely, and this is something I have wished for forever.Something as simple as "reverse=3DT" to be interpreted only when"rank=3Doff" is used might be an easy way to do it.Christophe. What is your view on this challenge/possibility?/Palle> On 10/02/2015, at 23.24, Stuart Tremain wrote:>=20> Put another field in you db named SORTORDER which could be populated =AUTONUMBER=3DSORTORDER this will be populated from 1 - n>=20> Then just do a normal sort on SORTORDER>=20>=20> Kind regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au >=20>=20>=20>=20>=20>> 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 > --------------------------------------------------------- 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=_56B4B39B-ABD8-4A5A-82F2-B854C98DB0C3Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8