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=3Ddes Maybe 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=3Ddes Maybe 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:
Cannot open database (1999)
WebCat cannot handle compatible search parameters? (1997)
[Semi-OT] Eaaaaaasy OSX FTP (2003)
Showif Error Generated... (2003)
[OT] Appropriate Signature??? (2003)
Moving files from one server to another... (2001)
Failing Email (2004)
NEW INFO: I'm stuck: Can't open order file. Ignoring[OrderFile] context (2000)
search double negative comparison (2001)
[showif] or-ing (1999)
Thanks ! (1997)
Feature: TCPconnect via SSL (1999)
change the number format (1997)
[isfile] ? (1997)
Multiple Pulldowns (1997)
Migrating to NT (1997)
checking for [ and ] in form fields ... (1997)
shortening the cart (1998)
Pass a form (2003)
Dynamically Generated Pages & WC? (2000)