Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113689
interpreted = N
texte = 1284 --Apple-Mail=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Stephen A little bit vague on what you are trying to achieve but: You may have to do 7 searches, and then sort the searches by hour for = that day. Search for all records =3D Monday sorted by hours There could be easier ways to achieve this depending on how you have set = up your db. If you have 40 fields in your db, why not give them a = position number i.e. 01 - 40 and then just sort by position number ? Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 16 Oct 2017, at 15:29, 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=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Stephen

A little bit vague on what you are trying to achieve but:

You may = have to do 7 searches, and then sort the searches by hour for that = day.

Search for all = records =3D Monday sorted by hours

There could be easier ways to achieve = this depending on how you have set up your db. If you have 40 fields in = your db, why not give them a position number i.e. 01 - 40 and then just = sort by position number ?





Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 16 Oct 2017, at 15:29, 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=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF-- . 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)
1284 --Apple-Mail=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Stephen A little bit vague on what you are trying to achieve but: You may have to do 7 searches, and then sort the searches by hour for = that day. Search for all records =3D Monday sorted by hours There could be easier ways to achieve this depending on how you have set = up your db. If you have 40 fields in your db, why not give them a = position number i.e. 01 - 40 and then just sort by position number ? Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 16 Oct 2017, at 15:29, 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=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Stephen

A little bit vague on what you are trying to achieve but:

You may = have to do 7 searches, and then sort the searches by hour for that = day.

Search for all = records =3D Monday sorted by hours

There could be easier ways to achieve = this depending on how you have set up your db. If you have 40 fields in = your db, why not give them a position number i.e. 01 - 40 and then just = sort by position number ?





Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 16 Oct 2017, at 15:29, 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=_DD1FC003-424B-4FB1-B87D-D6E9C0840EEF-- . Stuart Tremain

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:

Nutscrape Doesn't Render Right (2002) Explorer 3.0/ Access Denied! (1997) How to add product size choices to form? (1997) New Command prefs ... (1997) (1998) Practice runs ? (1997) Or Searches (2004) using WebCat for Associate Programs? (1998) WebCatalog-NT?'s (1996) Format question WC Mac f3 (1997) Checkboxes (1998) Apache 2.x .tpl mime types config? (2005) form data submission gets truncated (1997) More Shopping Cart Problems (2000) Formating found categories (1997) HELP WITH DATES (1997) Carrying over data? (1997) Database Import/Export (1998) Help! Odd, irreproducible happenings. (1998) WebCat2.0 [format thousands .0f] no go (1997)