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

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 = 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