Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113690
interpreted = N
texte = 1285 --Apple-Mail=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I was thinking the same thing. Probably not a big help or what you want to hear but I would consider = reorganizing this data so that it is properly normalized. For example consider the following field structure SKU, DOW, SH, EH 1000,6,3,5 (Thats a day 6 block for 3 to 5pm) This way you have essentiality the same data and now you can group your = results VERY easily buy Day of the week, start times or endtimes. While it feels like you have more data this way, you actually have a ton = less as in any standard DBS system you are blocking memory for fields = without or without data. And in the way you=E2=80=99re dealing with now = you not only are repeating verbose days over and over (lots more text = data), but also settings placeholder for ~40 fields simply for 3 data = elements. If you really want to do this right I would make the DOW a r_DOW field = where the number relates to a related sku in a day table so that you can = easily adjust spellings or dat abbreviations in Data and not in code. HTH AJ > On Oct 18, 2017, at 4:59 AM, Stuart Tremain = wrote: >=20 > Hi Stephen >=20 > A little bit vague on what you are trying to achieve but: >=20 > You may have to do 7 searches, and then sort the searches by hour for = that day. >=20 > Search for all records =3D Monday sorted by hours >=20 > 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 ? >=20 >=20 >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> 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 > --------------------------------------------------------- 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=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I was thinking the same thing.

Probably not a big help = or what you want to hear but I would consider reorganizing this data so = that it is properly normalized.

For example consider the following = field structure

SKU, DOW, SH, EH

1000,6,3,5

(Thats a day 6 block for 3 to 5pm)

This way you have essentiality the same = data and now you can group your results VERY easily buy Day of the week, = start times or endtimes.

While it feels like you have more data this way, you actually = have a ton less as in any standard DBS system you are blocking memory = for fields without or without data. And in the way you=E2=80=99re = dealing with now you not only are repeating verbose days over and over = (lots more text data), but also settings placeholder for ~40 fields = simply for 3 data elements.


If you really want to = do this right I would make the DOW a r_DOW field where the number = relates to a related sku in a day table so that you can easily adjust = spellings or dat abbreviations in Data and not in code.


HTH

AJ




On = Oct 18, 2017, at 4:59 AM, Stuart Tremain <webdna@idfk.com.au> = wrote:

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

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

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

= --------------------------------------------------------- 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=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70-- . 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)
1285 --Apple-Mail=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I was thinking the same thing. Probably not a big help or what you want to hear but I would consider = reorganizing this data so that it is properly normalized. For example consider the following field structure SKU, DOW, SH, EH 1000,6,3,5 (Thats a day 6 block for 3 to 5pm) This way you have essentiality the same data and now you can group your = results VERY easily buy Day of the week, start times or endtimes. While it feels like you have more data this way, you actually have a ton = less as in any standard DBS system you are blocking memory for fields = without or without data. And in the way you=E2=80=99re dealing with now = you not only are repeating verbose days over and over (lots more text = data), but also settings placeholder for ~40 fields simply for 3 data = elements. If you really want to do this right I would make the DOW a r_DOW field = where the number relates to a related sku in a day table so that you can = easily adjust spellings or dat abbreviations in Data and not in code. HTH AJ > On Oct 18, 2017, at 4:59 AM, Stuart Tremain = wrote: >=20 > Hi Stephen >=20 > A little bit vague on what you are trying to achieve but: >=20 > You may have to do 7 searches, and then sort the searches by hour for = that day. >=20 > Search for all records =3D Monday sorted by hours >=20 > 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 ? >=20 >=20 >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> 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 > --------------------------------------------------------- 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=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
I was thinking the same thing.

Probably not a big help = or what you want to hear but I would consider reorganizing this data so = that it is properly normalized.

For example consider the following = field structure

SKU, DOW, SH, EH

1000,6,3,5

(Thats a day 6 block for 3 to 5pm)

This way you have essentiality the same = data and now you can group your results VERY easily buy Day of the week, = start times or endtimes.

While it feels like you have more data this way, you actually = have a ton less as in any standard DBS system you are blocking memory = for fields without or without data. And in the way you=E2=80=99re = dealing with now you not only are repeating verbose days over and over = (lots more text data), but also settings placeholder for ~40 fields = simply for 3 data elements.


If you really want to = do this right I would make the DOW a r_DOW field where the number = relates to a related sku in a day table so that you can easily adjust = spellings or dat abbreviations in Data and not in code.


HTH

AJ




On = Oct 18, 2017, at 4:59 AM, Stuart Tremain <webdna@idfk.com.au> = wrote:

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

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

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

= --------------------------------------------------------- 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=_B0F4F810-DC17-4D84-8E1F-BD7ADFCE0B70-- . Alex McCombie

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:

Just Testing (1997) [subtotal] (2000) Strange Search Results (2004) [WebDNA] HTTPS and authorization (2018) Summary layout (1997) Errata: WCS Newbie question (1997) Error 551 in Emailer (2000) Variable security (2000) Sort Order on a page search (1997) different show next (1997) Setting up shop (1997) [Replace] (2000) [WebDNA] Mac Mountain Lion installation (2013) [WebDNA] HTTP post help (2012) user authentication via TCPSend (2005) E-mailer error codes (1997) blank page from template (1997) Error after loading WebDNA (2004) [SubTotal] again (1998) WCS Newbie question (1997)