Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113685
interpreted = N
texte = 1280 --94eb2c12576e3f647c055ba274a4 Content-Type: text/plain; charset="UTF-8" I have an html form with 40ish checkboxes for hourly time spans of each day, which correspond to fields in the database. example: FRIDAY_1_3 FRIDAY_11_1 FRIDAY_3_5 FRIDAY_9_11 MONDAY_1_3 MONDAY_11_1 MONDAY_3_5 MONDAY_9_11 etc... The data in the fields looks like this: on on on on on 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: 3 2 4 1 7 6 8 5 thought then I might be able to sort by these numbers, but I didn't know how. Thanks for asking, sfb Stephen Braun Tailored Web Solutions steve@tailoredwebsolutions.net www.tailoredwebsolutions.com 315.343.1744 On Sun, Oct 15, 2017 at 10:58 PM, Brian Fries wrote: > Database sorting is always on one or more columns, and effects the order > of the rows returned. > > Perhaps you could give us an idea of the problem you are trying to solve, > and we could be of more help. > > - Brian > > On Oct 15, 2017, at 7:50 PM, Steve @ Tailored Web Solutions < > steve@tailoredwebsolutions.net> 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 database 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=55 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=55 >> 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=55 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=55 Bug Reporting: support@webdna.us > --94eb2c12576e3f647c055ba274a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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_3= MONDAY_11_1MONDAY_3_5MONDAY_9_11=C2=A0etc...
The data in t= he fields=C2=A0looks like this: =C2=A0=C2=A0ononononon

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 valu= e to each field: =C2=A032417= 685
thought then I might be able to s= ort by these numbers, but I didn't know how.

Thanks for asking,
sf= b





Stephen Braun

On Sun, Oct 15, 2017 at 10:58 PM, Brian Frie= s <iphonzie@gmail.com> wrote:
Database sorting is always on one = or more columns, and effects the order of the rows returned.

=
Perhaps you could give us an idea of the problem you are trying to sol= ve, and we could be of more help.

- Brian

On Oct 15, 2017, at 7:= 50 PM, Steve @ Tailored Web Solutions <steve@tailoredwebsolutions.net&= gt; wrote:

Yes, I can sort by one or more (vertical) (column)= fields

Is it possible to sort by (horizontal) rows?

Thanks,
sfb


Stephen Braun

On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Gro= me <ken@webdnasolutions.com> 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 r= ow?
>
> Thanksomuch,
> sfb
>
>
>
>
>
>
> Stephen F Braun
> = sbraun1@twcny.rr.com <mailto:sbraun1@twcny.rr.com>
> --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing
> list talk@webdna.u= s To unsubscribe, E-mail to:
> talk-leave@w= ebdna.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@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@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 --94eb2c12576e3f647c055ba274a4-- . 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)
1280 --94eb2c12576e3f647c055ba274a4 Content-Type: text/plain; charset="UTF-8" I have an html form with 40ish checkboxes for hourly time spans of each day, which correspond to fields in the database. example: FRIDAY_1_3 FRIDAY_11_1 FRIDAY_3_5 FRIDAY_9_11 MONDAY_1_3 MONDAY_11_1 MONDAY_3_5 MONDAY_9_11 etc... The data in the fields looks like this: on on on on on 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: 3 2 4 1 7 6 8 5 thought then I might be able to sort by these numbers, but I didn't know how. Thanks for asking, sfb Stephen Braun Tailored Web Solutions steve@tailoredwebsolutions.net www.tailoredwebsolutions.com 315.343.1744 On Sun, Oct 15, 2017 at 10:58 PM, Brian Fries wrote: > Database sorting is always on one or more columns, and effects the order > of the rows returned. > > Perhaps you could give us an idea of the problem you are trying to solve, > and we could be of more help. > > - Brian > > On Oct 15, 2017, at 7:50 PM, Steve @ Tailored Web Solutions < > steve@tailoredwebsolutions.net> 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 database 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=55 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=55 >> 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=55 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=55 Bug Reporting: support@webdna.us > --94eb2c12576e3f647c055ba274a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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_3= MONDAY_11_1MONDAY_3_5MONDAY_9_11=C2=A0etc...
The data in t= he fields=C2=A0looks like this: =C2=A0=C2=A0ononononon

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 valu= e to each field: =C2=A032417= 685
thought then I might be able to s= ort by these numbers, but I didn't know how.

Thanks for asking,
sf= b





Stephen Braun

On Sun, Oct 15, 2017 at 10:58 PM, Brian Frie= s <iphonzie@gmail.com> wrote:
Database sorting is always on one = or more columns, and effects the order of the rows returned.

=
Perhaps you could give us an idea of the problem you are trying to sol= ve, and we could be of more help.

- Brian

On Oct 15, 2017, at 7:= 50 PM, Steve @ Tailored Web Solutions <steve@tailoredwebsolutions.net&= gt; wrote:

Yes, I can sort by one or more (vertical) (column)= fields

Is it possible to sort by (horizontal) rows?

Thanks,
sfb


Stephen Braun

On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Gro= me <ken@webdnasolutions.com> 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 r= ow?
>
> Thanksomuch,
> sfb
>
>
>
>
>
>
> Stephen F Braun
> = sbraun1@twcny.rr.com <mailto:sbraun1@twcny.rr.com>
> --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing
> list talk@webdna.u= s To unsubscribe, E-mail to:
> talk-leave@w= ebdna.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@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@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 --94eb2c12576e3f647c055ba274a4-- . "Steve @ Tailored Web Solutions"

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:

Ruby on Rails (was Looping Search) (2006) PCS Frames-Default page is solution! (1997) autocommit problem (1998) [OT] JavaScript Error (2002) Another question (1997) Opinion: [input] should be called [output] ... (1997) Running 2 two WebCatalog.acgi's (1996) Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998) test (2008) [SearchString] (1998) WebCat Refrence problem (2000) shownext and searches (2002) crash again (1998) off-topic: SMS interface? (2001) Emailer help....! (1997) Re:PCS Customer submissions ? (1997) Protect vs Authenicate (1997) RAM variables (1997) F3 crashing server (1997) syntax question, not in online refernce (1997)