Re: [WebDNA] Sort by Row
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113686
interpreted = N
texte = 1281Maybe you are looking for something like this:[listfields db=3Dxxx.db][search db=3Dxxx.db&ne[fieldname]datarq=3D[blank]][founditems][/founditems][/search][/listfields]Renaming your fields will get the results in chronological order.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 10/15/2017 11:29 PM, Steve @ Tailored Web Solutions wrote:> I have an html form with 40ish checkboxes for hourly time spans of> each day, which correspond to fields in the database.> example: =C2=A0 =C2=A0> =C2=A0FRIDAY_1_3FRIDAY_11_1FRIDAY_3_5FRIDAY_9_11MONDAY_1_3MONDAY_11_1MO=NDAY_3_5MONDAY_9_11=C2=A0etc...> The data in the fields=C2=A0looks like this: =C2=A0=C2=A0ononononon>=20> The customer has asked me to sort the entire db by the days of the> week, then the hours of each day.> So I thought that if I assigned a number value to each field:> =C2=A032417685> thought then I might be able to sort by these numbers, but I> didn't know how.>=20> Thanks for asking,> sfb>=20>=20>=20>=20>=20> Stephen Braun> Tailored Web Solutions> steve@tailoredwebsolutions.net
> www.tailoredwebsolutions.com > 315.343.1744>=20> On Sun, Oct 15, 2017 at 10:58 PM, Brian Fries > wrote:>=20> Database sorting is always on one or more columns, and effects> the order of the rows returned.>=20> Perhaps you could give us an idea of the problem you are> trying to solve, and we could be of more help.>=20> - Brian>=20>> On Oct 15, 2017, at 7:50 PM, Steve @ Tailored Web Solutions>> > > wrote:>>>> Yes, I can sort by one or more (vertical) (column) fields>>>> Is it possible to sort by (horizontal) rows?>>>> Thanks,>> sfb>>>>>> Stephen Braun>> Tailored Web Solutions>> steve@tailoredwebsolutions.net>> >> www.tailoredwebsolutions.com>> >> 315.343.1744>>>> On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Grome>> >>> wrote:>>>> You can sort by one or more fields.>>>> Regards,>> Kenneth Grome>> WebDNA Solutions>> http://www.webdnasolutions.com>> >> Web Database Systems and Linux Server Administration>>>>>> On 10/15/2017 11:41 AM, Stephen Braun wrote:>> > Good Day All,>> >>> > Is there a way to sort =C2=A0database results in a search>> command by row?>> >>> > Thanksomuch,>> > sfb>> >>> >>> >>> >>> >>> >>> > Stephen F Braun>> > sbraun1@twcny.rr.com >> >>> >>> --------------------------------------------------------- This>> > message is sent to you because you are subscribed to>> the mailing>> > list talk@webdna.us To>> unsubscribe, E-mail to:>> > talk-leave@webdna.us >> archives:>> > http://www.webdna.us/page.dna?numero=3D55>> Bug Reporting:>> > support@webdna.us >> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us>> >> archives: http://www.webdna.us/page.dna?numero=3D55>> >> Bug Reporting: support@webdna.us >>>>>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list talk@webdna.us To>> unsubscribe, E-mail to: talk-leave@webdna.us>> archives:>> http://www.webdna.us/page.dna?numero=3D55>> Bug Reporting:>> support@webdna.us >=20> --------------------------------------------------------- This> message is sent to you because you are subscribed to the> mailing list talk@webdna.us To> unsubscribe, E-mail to: talk-leave@webdna.us> archives:> http://www.webdna.us/page.dna?numero=3D55> Bug Reporting:> support@webdna.us >=20>=20> --------------------------------------------------------- This> message is sent to you because you are subscribed to the mailing> list talk@webdna.us To unsubscribe, E-mail to:> talk-leave@webdna.us archives:> http://www.webdna.us/page.dna?numero=3D55 Bug Reporting:> support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1281Maybe you are looking for something like this:[listfields db=3Dxxx.db][search db=3Dxxx.db&ne[fieldname]datarq=3D[blank]][founditems][/founditems][/search][/listfields]Renaming your fields will get the results in chronological order.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 10/15/2017 11:29 PM, Steve @ Tailored Web Solutions wrote:> I have an html form with 40ish checkboxes for hourly time spans of> each day, which correspond to fields in the database.> example: =C2=A0 =C2=A0> =C2=A0FRIDAY_1_3FRIDAY_11_1FRIDAY_3_5FRIDAY_9_11MONDAY_1_3MONDAY_11_1MO=NDAY_3_5MONDAY_9_11=C2=A0etc...> The data in the fields=C2=A0looks like this: =C2=A0=C2=A0ononononon>=20> The customer has asked me to sort the entire db by the days of the> week, then the hours of each day.> So I thought that if I assigned a number value to each field:> =C2=A032417685> thought then I might be able to sort by these numbers, but I> didn't know how.>=20> Thanks for asking,> sfb>=20>=20>=20>=20>=20> Stephen Braun> Tailored Web Solutions> steve@tailoredwebsolutions.net > www.tailoredwebsolutions.com > 315.343.1744>=20> On Sun, Oct 15, 2017 at 10:58 PM, Brian Fries > wrote:>=20> Database sorting is always on one or more columns, and effects> the order of the rows returned.>=20> Perhaps you could give us an idea of the problem you are> trying to solve, and we could be of more help.>=20> - Brian>=20>> On Oct 15, 2017, at 7:50 PM, Steve @ Tailored Web Solutions>> > > wrote:>>>> Yes, I can sort by one or more (vertical) (column) fields>>>> Is it possible to sort by (horizontal) rows?>>>> Thanks,>> sfb>>>>>> Stephen Braun>> Tailored Web Solutions>> steve@tailoredwebsolutions.net>> >> www.tailoredwebsolutions.com>> >> 315.343.1744>>>> On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Grome>> >>> wrote:>>>> You can sort by one or more fields.>>>> Regards,>> Kenneth Grome>> WebDNA Solutions>> http://www.webdnasolutions.com>> >> Web Database Systems and Linux Server Administration>>>>>> On 10/15/2017 11:41 AM, Stephen Braun wrote:>> > Good Day All,>> >>> > Is there a way to sort =C2=A0database results in a search>> command by row?>> >>> > Thanksomuch,>> > sfb>> >>> >>> >>> >>> >>> >>> > Stephen F Braun>> > sbraun1@twcny.rr.com >> >>> >>> --------------------------------------------------------- This>> > message is sent to you because you are subscribed to>> the mailing>> > list talk@webdna.us To>> unsubscribe, E-mail to:>> > talk-leave@webdna.us >> archives:>> > http://www.webdna.us/page.dna?numero=3D55>> Bug Reporting:>> > support@webdna.us >> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us>> >> archives: http://www.webdna.us/page.dna?numero=3D55>> >> Bug Reporting: support@webdna.us >>>>>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list talk@webdna.us To>> unsubscribe, E-mail to: talk-leave@webdna.us>> archives:>> http://www.webdna.us/page.dna?numero=3D55>> Bug Reporting:>> support@webdna.us >=20> --------------------------------------------------------- This> message is sent to you because you are subscribed to the> mailing list talk@webdna.us To> unsubscribe, E-mail to: talk-leave@webdna.us> archives:> http://www.webdna.us/page.dna?numero=3D55> Bug Reporting:> support@webdna.us >=20>=20> --------------------------------------------------------- This> message is sent to you because you are subscribed to the mailing> list talk@webdna.us To unsubscribe, E-mail to:> talk-leave@webdna.us archives:> http://www.webdna.us/page.dna?numero=3D55 Bug Reporting:> support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Kenneth Grome
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:
Code database (1998)
date tag not interpreted (2000)
redirect with frames (1997)
Credit card types (1997)
4.5 License (2005)
search context w shownext works! (1997)
question: webmerchant connection (1997)
Sorting by date (1997)
Help with Repost Data msg from form (1997)
Entry point? Security w/ dbase helper? (1997)
Replace context problem ... (1997)
ConvertChars (1998)
Summing fields (1997)
many-to-one problem (1998)
Browser frames and URLs in the Location field (2004)
AutoNumber not working (2004)
Re[2]: Re[3]: Problem with new formvariables (2000)
Alphabetically or numerically (1999)
One more try (1997)
convertwords BUG (2002)