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:
Format of Required fields error message (1997)
[url] link (1998)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Re[2]: Next X hits (1996)
shaopping cart limits (2000)
multi-paragraph fields (1997)
Replacing entry (1998)
random in arizona (2003)
Username for Admin Group (1997)
Emailer Error 550 (Was Strange Crash) (1998)
first time using webcats sendmail option (2001)
[numFound] inside [showIf]? (2000)
WCS Newbie question (1997)
emailer truncates last letter! (1997)
Pithy questions on webcommerce & siteedit (1997)
can WC render sites out? (1997)
[WebDNA] how to make webroot the start of path (2017)
PCS Frames (1997)
Searching for all records (1998)
WC 2.0 frames feature (1997)