Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113688
interpreted = N
texte = 1283 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Stephen - Still a bit unclear on your goal. Are you trying to list all records = with [MONDAY_1_3]=3Don followed by those with [MONDAY_3_5]=3Don, etc? If = so, should records with both fields ON show up twice, or only in the = first group? I=E2=80=99m sure there are ways to solve your dilemma, but so far = we=E2=80=99re still stabbing in the dark. If you provide an example data set and your desired results, we could do = more, as it sounds like an interesting challenge. - Brian > On Oct 15, 2017, at 9:29 PM, Steve @ Tailored Web Solutions = wrote: >=20 > 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_3FRIDAY_11_1= FRIDAY_3_5FRIDAY_9_11= MONDAY_1_3MONDAY_11_1= MONDAY_3_5MONDAY_9_11 etc... > The data in the fields looks like this: onon= on= onon >=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: 3= 241= 768= 5 > 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: > 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: >>=20 >> Yes, I can sort by one or more (vertical) (column) fields >>=20 >> Is it possible to sort by (horizontal) rows? >>=20 >> Thanks, >> sfb >>=20 >>=20 >> Stephen Braun >> Tailored Web Solutions >> steve@tailoredwebsolutions.net >> www.tailoredwebsolutions.com >> 315.343.1744 >>=20 >> On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Grome = > wrote: >> You can sort by one or more fields. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >>=20 >> 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=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 > --------------------------------------------------------- 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 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Stephen -

Still a bit unclear on your goal. Are you trying to list all = records with [MONDAY_1_3]=3Don followed by those with [MONDAY_3_5]=3Don, = etc? If so, should records with both fields ON show up twice, or only in = the first group?

I=E2=80= =99m sure there are ways to solve your dilemma, but so far we=E2=80=99re = still stabbing in the dark.

If you provide an example data set and your desired results, = we could do more, as it sounds like an interesting challenge.

- Brian


On = Oct 15, 2017, at 9:29 PM, Steve @ Tailored Web Solutions <steve@tailoredwebsolutions.net> wrote:

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 <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 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 <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  database results in a search command = by row?
>
> 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.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

--------------------------------------------------------- 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 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE-- . 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)
1283 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Stephen - Still a bit unclear on your goal. Are you trying to list all records = with [MONDAY_1_3]=3Don followed by those with [MONDAY_3_5]=3Don, etc? If = so, should records with both fields ON show up twice, or only in the = first group? I=E2=80=99m sure there are ways to solve your dilemma, but so far = we=E2=80=99re still stabbing in the dark. If you provide an example data set and your desired results, we could do = more, as it sounds like an interesting challenge. - Brian > On Oct 15, 2017, at 9:29 PM, Steve @ Tailored Web Solutions = wrote: >=20 > 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_3FRIDAY_11_1= FRIDAY_3_5FRIDAY_9_11= MONDAY_1_3MONDAY_11_1= MONDAY_3_5MONDAY_9_11 etc... > The data in the fields looks like this: onon= on= onon >=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: 3= 241= 768= 5 > 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: > 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: >>=20 >> Yes, I can sort by one or more (vertical) (column) fields >>=20 >> Is it possible to sort by (horizontal) rows? >>=20 >> Thanks, >> sfb >>=20 >>=20 >> Stephen Braun >> Tailored Web Solutions >> steve@tailoredwebsolutions.net >> www.tailoredwebsolutions.com >> 315.343.1744 >>=20 >> On Sun, Oct 15, 2017 at 7:12 PM, Kenneth Grome = > wrote: >> You can sort by one or more fields. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >>=20 >> 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=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 > --------------------------------------------------------- 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 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Stephen -

Still a bit unclear on your goal. Are you trying to list all = records with [MONDAY_1_3]=3Don followed by those with [MONDAY_3_5]=3Don, = etc? If so, should records with both fields ON show up twice, or only in = the first group?

I=E2=80= =99m sure there are ways to solve your dilemma, but so far we=E2=80=99re = still stabbing in the dark.

If you provide an example data set and your desired results, = we could do more, as it sounds like an interesting challenge.

- Brian


On = Oct 15, 2017, at 9:29 PM, Steve @ Tailored Web Solutions <steve@tailoredwebsolutions.net> wrote:

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 <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 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 <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  database results in a search command = by row?
>
> 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.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

--------------------------------------------------------- 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 --Apple-Mail=_D86ADB4B-5FC5-4831-8FF1-8A69318C93CE-- . Brian Fries

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:

SiteBuilder and reportin on page hits (awstats) (2006) Changing Date Format in Field (1999) Date search - yes or no (1997) [isfile] ? (1997) Site Check (2006) WebCatalog for guestbook ? (1997) all records returned. (1997) Did you hear about this? (1997) Smith Micro Support powerd by PHP (2006) RE: webcat license???? (1997) Make sure I understand this??? (1997) WC2b15 File Corruption (1997) question: search return in order (1997) [convertchars] limits (1998) creator code (1997) Memory Error message (1998) taxrate - off by 1 cent (1997) RAM variables (1997) ShipCosts database (1997) [OT] Internet connection problem (2003)