Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113686
interpreted = N
texte = 1281 Maybe 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 Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 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 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 . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Sort by Row ("Steve @ Tailored Web Solutions" 2017)
  2. Re: [WebDNA] Sort by Row (Alex McCombie 2017)
  3. Re: [WebDNA] Sort by Row (Stuart Tremain 2017)
  4. Re: [WebDNA] Sort by Row (Brian Fries 2017)
  5. Re: [WebDNA] Sort by Row (Stuart Tremain 2017)
  6. Re: [WebDNA] Sort by Row (Kenneth Grome 2017)
  7. Re: [WebDNA] Sort by Row ("Steve @ Tailored Web Solutions" 2017)
  8. Re: [WebDNA] Sort by Row (Brian Fries 2017)
  9. Re: [WebDNA] Sort by Row ("Steve @ Tailored Web Solutions" 2017)
  10. Re: [WebDNA] Sort by Row (Kenneth Grome 2017)
  11. [WebDNA] Sort by Row (Stephen Braun 2017)
1281 Maybe 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 Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 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 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 . 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)