Re: [WebDNA] Sort Direction matches the written to file order
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112114
interpreted = N
texte = It looks doable to do something like rank=3DdesMaybe the small group reluctant to add anything to WebDNA could offer an =alternative built with the existing tags?- chris> On 11 Feb 2015, at 10:53, Palle Bo Nielsen
=wrote:>=20> Hi Stuart>=20> 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=3DT=rue=E2=80=99 would be a perfect solution.=20>=20> Is still see the need of a WebDNA Function which can help here...>=20>=20> 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?>=20> 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.>=20>=20> Christophe. What is your view on this challenge/possibility?>=20> /Palle>=20>=20>=20>=20>=20>> 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>>>>>=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>>>=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>>=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>=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
Associated Messages, from the most recent to the oldest:
It looks doable to do something like rank=3DdesMaybe the small group reluctant to add anything to WebDNA could offer an =alternative built with the existing tags?- chris> On 11 Feb 2015, at 10:53, Palle Bo Nielsen =wrote:>=20> Hi Stuart>=20> 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=3DT=rue=E2=80=99 would be a perfect solution.=20>=20> Is still see the need of a WebDNA Function which can help here...>=20>=20> 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?>=20> 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.>=20>=20> Christophe. What is your view on this challenge/possibility?>=20> /Palle>=20>=20>=20>=20>=20>> 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>>>>>=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>>>=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>>=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>=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
christophe.billiottet@webdna.us
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:
[WebDNA] Limited Time Discount on WebDNA Server licenses (2013)
Different Tax levels (1998)
unsubscribe (1997)
Last desperate attempt (1998)
Append again (1999)
[WebDNA] Paypal Cert (2015)
Problem (1997)
SendTo more emails (1998)
WebCatalog/Mac 2.1b2 - PIXO (1997)
Requiring that certain fields be completed (1997)
Re:E-Mailer (WebCatb15acgiMac) (1997)
[WriteFile] problems (1997)
Looping control (1997)
WebCat2_Mac RETURNs in .db (1997)
[WebDNA] php/mySQL version of WebDNA Speed Test? (2009)
[WebDNA] sagepayments TLS? requests now failing (2018)
[WebDNA] [OT] Google redirect or not (2014)
Triggers (1999)
Resume Catalog ? (1997)
Email within tmpl ? (1997)