Re: [WebDNA] Sort by Row

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113691
interpreted = N
texte = 1286 --001a114f1b2ab1f1e8055bd1da1d Content-Type: multipart/alternative; boundary="001a114f1b2ab1f1e5055bd1da1b" --001a114f1b2ab1f1e5055bd1da1b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is exactly what I was trying to do. I gave each field a number in the first record position. I still don't know how to sort by that first record position. Are you saying that I should rename all of my fields to something numeric? That occurred to me, but it would be a lot of work. I'm using these 40ish fields names in dozens of other files. Thanks again for all of your input, sfb Stephen Braun Tailored Web Solutions steve@tailoredwebsolutions.net www.tailoredwebsolutions.com 315.343.1744 On Wed, Oct 18, 2017 at 7:39 AM, Alex McCombie wrote: > 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 y= ou 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: > > 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 tha= t > 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 positio= n > 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 < > 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 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=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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --001a114f1b2ab1f1e5055bd1da1b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This is exactly what I was trying to do.
I gave each f= ield a number in the first record position.
I still don't kno= w how to sort by that first record position.

Are y= ou saying that I should rename all of my fields to something numeric? =C2= =A0
That occurred to me, but it would be a lot of work.
I'm using these 40ish fields names in dozens of other files.

Thanks again for all of your input,
sfb







=
Stephen Braun=

On Wed, Oct 18, 2017 at 7:39 AM, Alex McComb= ie <alex@mccombie.com> wrote:
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 normaliz= ed.

For example consider the following field struc= ture

SKU, DOW, SH, EH

100= 0,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 endt= imes.

While it feels like you have more data this = way, you actually have a ton less as in any standard DBS system you are blo= cking 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 ove= r (lots more text data), but also settings placeholder for ~40 fields simpl= y for 3 data elements.


If you reall= y 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 spel= lings 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:<= /div>
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 ho= w you have set up your db. If you have 40 fields in your db, why not give t= hem a position number i.e. 01 - 40 and then just sort by position number ?<= br>





Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On 16 Oct 2017, at 15:29, Steve @ T= ailored 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: =C2=A0 = =C2=A0 =C2=A0FRIDAY_1_3FRIDAY_11_1FRIDA= Y_3_5FRIDAY_9_11MONDAY_1_3MONDAY_11_1MONDAY_3_5MONDAY_9_11=C2=A0= etc...
The data in the fields=C2=A0looks like this: =C2=A0= =C2=A0onon= on= onon
<= br>
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 t= o each field: =C2=A03241= 76<= span style=3D"font-size:x-small;white-space:pre-wrap">85
t= hought then I might be able to sort by these numbers, but I didn't know= how.

Thanks for asking,
sfb


<= br>


Ste= phen 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 Solutio= ns <= 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.com315.343.1744<= /span>

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@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 --001a114f1b2ab1f1e5055bd1da1b-- --001a114f1b2ab1f1e8055bd1da1d Content-Type: text/plain; charset="US-ASCII"; name="database file.txt" Content-Disposition: attachment; filename="database file.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j8x1s0ua0 U0tVCQlGSVJTVF9OQU1FCUxBU1RfTkFNRQkJTk9URVMJCUFERFJFU1MJCQlDSVRZCQlaSVAJCUhP TUVfUEhPTkUJCUNFTExfUEhPTkUJCVdPUktfUEhPTkUJCUVNQUlMCQlFTUFJTF9WQUwJCQkJU1RB VEUJCUVNQUlMXzIJCUZPUk1fREFURQkJQUNUSVZFCQkJCQlGUklEQVlfMV8zCQkJRlJJREFZXzEx XzEJCQlGUklEQVlfM181CQkJRlJJREFZXzlfMTEJCQlGUklEQVlfQUxMX0RBWQkJCUZSSURBWV9B U19ORUVERUQJCQlNT05EQVlfMV8zCQkJTU9OREFZXzExXzEJCQlNT05EQVlfM181CQkJTU9OREFZ XzlfMTEJCQlNT05EQVlfQUxMX0RBWQkJCU1PTkRBWV9BU19ORUVERUQJCQlNT05EQVkyXzFfMwkJ CU1PTkRBWTJfMTFfMQkJCU1PTkRBWTJfM181CQkJTU9OREFZMl85XzExCQkJTU9OREFZMl9BTExf REFZCQkJTU9OREFZMl9BU19ORUVERUQJCQlTQVRVUkRBWV8xXzMJCQlTQVRVUkRBWV8xMV8xCQkJ U0FUVVJEQVlfM181CQkJU0FUVVJEQVlfOV8xMQkJCVNBVFVSREFZX0FMTF9EQVkJCQlTQVRVUkRB WV9BU19ORUVERUQJCQlTVU5EQVlfMV8zCQkJU1VOREFZXzExXzEJCQlTVU5EQVlfM181CQkJU1VO REFZXzlfMTEJCQlTVU5EQVlfQUxMX0RBWQkJCVNVTkRBWV9BU19ORUVERUQJCQlUSFVSU0RBWV8x XzMJCQlUSFVSU0RBWV8xMV8xCQkJVEhVUlNEQVlfM181CQkJVEhVUlNEQVlfOV8xMQkJCVRIVVJT REFZX0FMTF9EQVkJCQlUSFVSU0RBWV9BU19ORUVERUQJCQlUVUVTREFZXzFfMwkJCVRVRVNEQVlf MTFfMQkJCVRVRVNEQVlfM181CQkJVFVFU0RBWV85XzExCQkJVFVFU0RBWV9BTExfREFZCQkJVFVF U0RBWV9BU19ORUVERUQJCQlXRURORVNEQVlfMV8zCQkJV0VETkVTREFZXzExXzEJCQlXRURORVNE QVlfM181CQkJV0VETkVTREFZXzlfMTEJCQlXRURORVNEQVlfQUxMX0RBWQkJCVdFRE5FU0RBWV9B U19ORUVERUQJCU1PRF9EQVRFCQlNT0RfVElNRQo5OTkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJMjcJCQkyNgkJCTI4CQkJMjUJCQkyOQkJCTMwCQkJMwkJCTIJCQk0CQkJMQkJ CTUJCQk2CQkJCQkJCQkJCQkJCQkJCQkJMzcJCQkJCQkJCQkJCQkJCQkJCQkJCQkzMwkJCTMyCQkJ MzQJCQkzMQkJCTM1CQkJMzYJCQkyMQkJCTIwCQkJMjIJCQkxOQkJCTIzCQkJMjQJCQk5CQkJOAkJ CTEwCQkJNwkJCTExCQkJMTIJCQkxNQkJCTE0CQkJMTYJCQkxMwkJCTE3CQkJMTgJCQkJCjEwMDAJ CU1hcmNpYQlYWFhYCQkJCVhYWFgJCQlGdWx0b24JCVhYWFgJCQkJWFhYWAkJWFhYWAkJWFhYWAkJ CQkJCQkJCQkxMC8xMC8xNwkJWWVzCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCQkJCQkJCQkJCW9u CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQlvbgkJCQkJCQkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQkJCQlvbgkJCQkJ CQkJCQkJCQkJCQkJCQkKMTAwMQkJUGF0cmljawlYWFhYCQkJCVhYWFgJCQlPc3dlZ28JCVhYWFgJ CQkJWFhYWAkJCQlYWFhYCQkJCQkJCQkJCTEwLzEwLzE3CQlZZXMJCQkJCW9uCQkJb24JCQkJCQlv bgkJCQkJCQkJCW9uCQkJb24JCQkJCQlvbgkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQlv bgkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCjEwMDIJCVBhdHJpY2sJWFhY WAkJCQlYWFhYCQkJRnVsdG9uCQlYWFhYCQkJCVhYWFgJCQkJWFhYWAkJCQkJCQkJCQkxMC8xMS8x NwkJWWVzCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCW9uCQkJCQkJb24JCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCW9uCQkJ b24JCQkJCQlvbgkJCQkJCQkJCW9uCQkJb24JCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJ CQkJCQk= --001a114f1b2ab1f1e8055bd1da1d-- . 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)
1286 --001a114f1b2ab1f1e8055bd1da1d Content-Type: multipart/alternative; boundary="001a114f1b2ab1f1e5055bd1da1b" --001a114f1b2ab1f1e5055bd1da1b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is exactly what I was trying to do. I gave each field a number in the first record position. I still don't know how to sort by that first record position. Are you saying that I should rename all of my fields to something numeric? That occurred to me, but it would be a lot of work. I'm using these 40ish fields names in dozens of other files. Thanks again for all of your input, sfb Stephen Braun Tailored Web Solutions steve@tailoredwebsolutions.net www.tailoredwebsolutions.com 315.343.1744 On Wed, Oct 18, 2017 at 7:39 AM, Alex McCombie wrote: > 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 y= ou 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: > > 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 tha= t > 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 positio= n > 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 < > 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 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=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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --001a114f1b2ab1f1e5055bd1da1b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This is exactly what I was trying to do.
I gave each f= ield a number in the first record position.
I still don't kno= w how to sort by that first record position.

Are y= ou saying that I should rename all of my fields to something numeric? =C2= =A0
That occurred to me, but it would be a lot of work.
I'm using these 40ish fields names in dozens of other files.

Thanks again for all of your input,
sfb







=
Stephen Braun=

On Wed, Oct 18, 2017 at 7:39 AM, Alex McComb= ie <alex@mccombie.com> wrote:
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 normaliz= ed.

For example consider the following field struc= ture

SKU, DOW, SH, EH

100= 0,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 endt= imes.

While it feels like you have more data this = way, you actually have a ton less as in any standard DBS system you are blo= cking 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 ove= r (lots more text data), but also settings placeholder for ~40 fields simpl= y for 3 data elements.


If you reall= y 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 spel= lings 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:<= /div>
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 ho= w you have set up your db. If you have 40 fields in your db, why not give t= hem a position number i.e. 01 - 40 and then just sort by position number ?<= br>





Kind regards

Stua= rt Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On 16 Oct 2017, at 15:29, Steve @ T= ailored 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: =C2=A0 = =C2=A0 =C2=A0FRIDAY_1_3FRIDAY_11_1FRIDA= Y_3_5FRIDAY_9_11MONDAY_1_3MONDAY_11_1MONDAY_3_5MONDAY_9_11=C2=A0= etc...
The data in the fields=C2=A0looks like this: =C2=A0= =C2=A0onon= on= onon
<= br>
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 t= o each field: =C2=A03241= 76<= span style=3D"font-size:x-small;white-space:pre-wrap">85
t= hought then I might be able to sort by these numbers, but I didn't know= how.

Thanks for asking,
sfb


<= br>


Ste= phen 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 Solutio= ns <= 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.com315.343.1744<= /span>

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@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 --001a114f1b2ab1f1e5055bd1da1b-- --001a114f1b2ab1f1e8055bd1da1d Content-Type: text/plain; charset="US-ASCII"; name="database file.txt" Content-Disposition: attachment; filename="database file.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j8x1s0ua0 U0tVCQlGSVJTVF9OQU1FCUxBU1RfTkFNRQkJTk9URVMJCUFERFJFU1MJCQlDSVRZCQlaSVAJCUhP TUVfUEhPTkUJCUNFTExfUEhPTkUJCVdPUktfUEhPTkUJCUVNQUlMCQlFTUFJTF9WQUwJCQkJU1RB VEUJCUVNQUlMXzIJCUZPUk1fREFURQkJQUNUSVZFCQkJCQlGUklEQVlfMV8zCQkJRlJJREFZXzEx XzEJCQlGUklEQVlfM181CQkJRlJJREFZXzlfMTEJCQlGUklEQVlfQUxMX0RBWQkJCUZSSURBWV9B U19ORUVERUQJCQlNT05EQVlfMV8zCQkJTU9OREFZXzExXzEJCQlNT05EQVlfM181CQkJTU9OREFZ XzlfMTEJCQlNT05EQVlfQUxMX0RBWQkJCU1PTkRBWV9BU19ORUVERUQJCQlNT05EQVkyXzFfMwkJ CU1PTkRBWTJfMTFfMQkJCU1PTkRBWTJfM181CQkJTU9OREFZMl85XzExCQkJTU9OREFZMl9BTExf REFZCQkJTU9OREFZMl9BU19ORUVERUQJCQlTQVRVUkRBWV8xXzMJCQlTQVRVUkRBWV8xMV8xCQkJ U0FUVVJEQVlfM181CQkJU0FUVVJEQVlfOV8xMQkJCVNBVFVSREFZX0FMTF9EQVkJCQlTQVRVUkRB WV9BU19ORUVERUQJCQlTVU5EQVlfMV8zCQkJU1VOREFZXzExXzEJCQlTVU5EQVlfM181CQkJU1VO REFZXzlfMTEJCQlTVU5EQVlfQUxMX0RBWQkJCVNVTkRBWV9BU19ORUVERUQJCQlUSFVSU0RBWV8x XzMJCQlUSFVSU0RBWV8xMV8xCQkJVEhVUlNEQVlfM181CQkJVEhVUlNEQVlfOV8xMQkJCVRIVVJT REFZX0FMTF9EQVkJCQlUSFVSU0RBWV9BU19ORUVERUQJCQlUVUVTREFZXzFfMwkJCVRVRVNEQVlf MTFfMQkJCVRVRVNEQVlfM181CQkJVFVFU0RBWV85XzExCQkJVFVFU0RBWV9BTExfREFZCQkJVFVF U0RBWV9BU19ORUVERUQJCQlXRURORVNEQVlfMV8zCQkJV0VETkVTREFZXzExXzEJCQlXRURORVNE QVlfM181CQkJV0VETkVTREFZXzlfMTEJCQlXRURORVNEQVlfQUxMX0RBWQkJCVdFRE5FU0RBWV9B U19ORUVERUQJCU1PRF9EQVRFCQlNT0RfVElNRQo5OTkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJMjcJCQkyNgkJCTI4CQkJMjUJCQkyOQkJCTMwCQkJMwkJCTIJCQk0CQkJMQkJ CTUJCQk2CQkJCQkJCQkJCQkJCQkJCQkJMzcJCQkJCQkJCQkJCQkJCQkJCQkJCQkzMwkJCTMyCQkJ MzQJCQkzMQkJCTM1CQkJMzYJCQkyMQkJCTIwCQkJMjIJCQkxOQkJCTIzCQkJMjQJCQk5CQkJOAkJ CTEwCQkJNwkJCTExCQkJMTIJCQkxNQkJCTE0CQkJMTYJCQkxMwkJCTE3CQkJMTgJCQkJCjEwMDAJ CU1hcmNpYQlYWFhYCQkJCVhYWFgJCQlGdWx0b24JCVhYWFgJCQkJWFhYWAkJWFhYWAkJWFhYWAkJ CQkJCQkJCQkxMC8xMC8xNwkJWWVzCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCQkJCQkJCQkJCW9u CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQlvbgkJCQkJCQkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQkJCQlvbgkJCQkJ CQkJCQkJCQkJCQkJCQkKMTAwMQkJUGF0cmljawlYWFhYCQkJCVhYWFgJCQlPc3dlZ28JCVhYWFgJ CQkJWFhYWAkJCQlYWFhYCQkJCQkJCQkJCTEwLzEwLzE3CQlZZXMJCQkJCW9uCQkJb24JCQkJCQlv bgkJCQkJCQkJCW9uCQkJb24JCQkJCQlvbgkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCQkJCQlv bgkJCQkJCW9uCQkJCQkJCQkJCQkJCQkJCQkJCQkJb24JCQkJCQkJCjEwMDIJCVBhdHJpY2sJWFhY WAkJCQlYWFhYCQkJRnVsdG9uCQlYWFhYCQkJCVhYWFgJCQkJWFhYWAkJCQkJCQkJCQkxMC8xMS8x NwkJWWVzCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCW9uCQkJCQkJb24JCQkJCQkJCQkJCQkJ CQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJCQkJCW9uCQkJ b24JCQkJCQlvbgkJCQkJCQkJCW9uCQkJb24JCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQlvbgkJ CQkJCQk= --001a114f1b2ab1f1e8055bd1da1d-- . "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:

WebCat2: Items xx to xx shown, etc. (1997) Mac v. NT (1998) NT b19 sends extra MIME headers (1997) RE: Nesting [ListFiles] (1998) Can you do this??? and other stuff (1997) Return records from another (1997) Problem with pull down menu (1998) [OT] MacOs IE5 topmargin and leftmargin bug (2000) re:check boxes (1997) WebCat2 several catalogs? (1997) ANNC: BannerSleuth v2.0 Beta 1 (1999) Mac v. NT (1998) Sorting (1998) Bug in capitalize ... ? (2003) Submitting ampersands in forms... (1998) Sample Tearoom Search Error - Solved! (1997) Re:trouble (1997) Sorting by date (1997) GuestBook example (1997) PCS Frames (1997)