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:

Internet Advancement (2003) 'does not contain' operator needed ... (1997) Need relative path explanation (1997) multi-paragraph fields (1997) Return records from another (1997) Date or time comparisons have bugs ... (1998) Tiny Store (1998) Max Record length restated as maybe bug (1997) Shopping cart not being assigned (1999) [isfile] ? (1997) RE: Can a database get stomped by simultaneous access? (1997) [WebDNA] Cost to upgrade WebDNA 6.2 to run on Win2008 / Win7 (2012) Help with sorting search results sorting (1998) Possible Bug in 2.0b15.acgi (1997) GrandTotal not right (1997) Most Recent version of WebDNA For RH ES (2006) 2.0 Info (1997) Banners (1997) getting images' width/height (1998) Associative lookup style? (1997)