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:

Trunk-gator (1997) Can webcat 3.0/4.0 handle 1,000,000 hits a day? (2000) Separate SSL Server (1997) Resume Catalog ? (1997) I'm new be kind (1997) case sensitivity in lookups (1997) [WebDNA] EMailer timezone bug? (2015) Multihoming and webcat (1998) PCS Emailer's role ? (1997) Date or time comparisons have bugs ... (1998) Uploading out of FMP (2001) WebCat Emailer & Liststar (1997) Simultaneous Users (1999) WCS Newbie question (1997) Re1000001: Setting up shop (1997) Comments in db? (1997) Price Change (1999) WebCatalog not recognizing ShoppingCarts folder (2000) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) multiple search commands (1997)