Re: [WebDNA] Search not sorting

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113721
interpreted = N
texte = 1316 --Apple-Mail=_6820B922-21D6-4CA3-8509-790B5AD89B85 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Hi Ken All IT-PRICEs returned are numeric. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 12 Nov 2017, at 00:42, Kenneth Grome wrote: > > I don't remember if this will mess up the sorting, but check for a > non-numeric value in the IT-PRICE field. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > > > On 11/10/2017 06:34 PM, Stuart Tremain wrote: >> Hi >> >> >> Any idea why this search will not sort ? >> >> [SEARCH db=admin/data/items.db[!] >> [/!]&woIT-NAMEdata=[SEARCH-FOR][!] >> [/!]&IT-NAMEword=ww[!] >> [/!]&woIT-SHORTDESCdata=[SEARCH-FOR][!] >> [/!]&IT-SHORTDESCword=ww[!] >> [/!]&woIT-LONGDESCdata=[SEARCH-FOR][!] >> [/!]&IT-LONGDESCword=ww[!] >> [/!]&deIT-PRICEsort=1[!] >> [/!]&IT-PRICEtype=num[!] >> [/!]&max=100] >> >> >> >> Kind regards >> >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> >> >> >> >> >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing >> list talk@webdna.us To unsubscribe, E-mail to: >> talk-leave@webdna.us archives: >> http://www.webdna.us/page.dna?numero=55 Bug Reporting: >> support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=55 > Bug Reporting: support@webdna.us --Apple-Mail=_6820B922-21D6-4CA3-8509-790B5AD89B85 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Ken

All = IT-PRICEs returned are numeric.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 12 Nov 2017, at 00:42, Kenneth Grome <ken@webdnasolutions.com> wrote:

I = don't remember if this will mess up the sorting, but check for a
non-numeric value in the IT-PRICE field.

Regards,
Kenneth Grome
WebDNA = Solutions
http://www.webdnasolutions.com
Web Database = Systems and Linux Server Administration



On 11/10/2017 06:34 PM, Stuart Tremain = wrote:
Hi 


Any idea why this search will = not sort ?

[SEARCH = db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH-FOR][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&woIT-LONGDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-LONGDESCword=3Dww[!]
[/!]&deIT-PRICEsort=3D1[!]
[/!]&IT-PRICEtype=3Dnum[!]
[/!]&max=3D100]



Kind regards

Stuart= Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au <mailto:webdna@idfk.com.au>





--------------------------------------------------------- = 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=_6820B922-21D6-4CA3-8509-790B5AD89B85-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search not sorting (Stuart Tremain 2017)
  2. Re: [WebDNA] Search not sorting (Stuart Tremain 2017)
  3. Re: [WebDNA] Search not sorting (Kenneth Grome 2017)
  4. Re: [WebDNA] Search not sorting (Lawrence Banahan 2017)
  5. [WebDNA] Search not sorting (Stuart Tremain 2017)
1316 --Apple-Mail=_6820B922-21D6-4CA3-8509-790B5AD89B85 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Hi Ken All IT-PRICEs returned are numeric. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 12 Nov 2017, at 00:42, Kenneth Grome wrote: > > I don't remember if this will mess up the sorting, but check for a > non-numeric value in the IT-PRICE field. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > > > On 11/10/2017 06:34 PM, Stuart Tremain wrote: >> Hi >> >> >> Any idea why this search will not sort ? >> >> [SEARCH db=admin/data/items.db[!] >> [/!]&woIT-NAMEdata=[SEARCH-FOR][!] >> [/!]&IT-NAMEword=ww[!] >> [/!]&woIT-SHORTDESCdata=[SEARCH-FOR][!] >> [/!]&IT-SHORTDESCword=ww[!] >> [/!]&woIT-LONGDESCdata=[SEARCH-FOR][!] >> [/!]&IT-LONGDESCword=ww[!] >> [/!]&deIT-PRICEsort=1[!] >> [/!]&IT-PRICEtype=num[!] >> [/!]&max=100] >> >> >> >> Kind regards >> >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> >> >> >> >> >> >> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing >> list talk@webdna.us To unsubscribe, E-mail to: >> talk-leave@webdna.us archives: >> http://www.webdna.us/page.dna?numero=55 Bug Reporting: >> support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=55 > Bug Reporting: support@webdna.us --Apple-Mail=_6820B922-21D6-4CA3-8509-790B5AD89B85 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Ken

All = IT-PRICEs returned are numeric.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 12 Nov 2017, at 00:42, Kenneth Grome <ken@webdnasolutions.com> wrote:

I = don't remember if this will mess up the sorting, but check for a
non-numeric value in the IT-PRICE field.

Regards,
Kenneth Grome
WebDNA = Solutions
http://www.webdnasolutions.com
Web Database = Systems and Linux Server Administration



On 11/10/2017 06:34 PM, Stuart Tremain = wrote:
Hi 


Any idea why this search will = not sort ?

[SEARCH = db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH-FOR][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&woIT-LONGDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-LONGDESCword=3Dww[!]
[/!]&deIT-PRICEsort=3D1[!]
[/!]&IT-PRICEtype=3Dnum[!]
[/!]&max=3D100]



Kind regards

Stuart= Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au <mailto:webdna@idfk.com.au>





--------------------------------------------------------- = 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=_6820B922-21D6-4CA3-8509-790B5AD89B85-- . 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:

Convertchars Problem (2004) Bizarre behavior texta behavior (2004) [WebDNA] linux linux linux (2009) [protect] error page (1997) Kaaaaahhhhhhhnnnnnnn! (1997) Additional Subtotals (1999) Download URL & access on the fly ? (1997) Test (2003) Sort Order on a page search (1997) WebCat2 - [SendNews] (1997) Summing fields (1997) [OT] http list (2003) sharing cookie recepies (1998) programmer help needed (1998) Online reference (1997) [WebDNA] Internal [ipaddress] ? (2009) [protect] error page (1997) purchase.log file (1997) Re:2nd WebCatalog2 Feature Request (1996) [searchString] (1997)