Re: [WebDNA] Search not sorting

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113719
interpreted = N
texte = 1314 --001a114e51909fd669055db23051 Content-Type: text/plain; charset="UTF-8" Hi Stuart, What result do you get when you put a [numfound]? Have you tried step by step? [SEARCH db=admin/data/items.db[!] [/!]&woIT-NAMEdata=[SEARCH-FOR][!] [/!]&IT-NAMEword=ww[!] [/!]&max=100] then [SEARCH db=admin/data/items.db[!] [/!]&woIT-NAMEdata=[SEARCH-FOR][!] [/!]&IT-NAMEword=ww[!] [/!]&woIT-SHORTDESCdata=[SEARCH-FOR][!] [/!]&IT-SHORTDESCword=ww[!] [/!]&max=100] and your final search In this kind of big search I prefer creating a table at each step and search in the new table, its all in RAM so it goes preaty fast. I hope this helps Lawrence 2017-11-11 1:34 GMT+01:00 Stuart Tremain : > 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 --001a114e51909fd669055db23051 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Stuart,
What result do you get when = you put a [numfound]?
Have you tried step by step?

[SE= ARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH= -FOR][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&max= =3D100]
then
[SEARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH-FOR][!]
[/!]&I= T-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR= ][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&max=3D1= 00]
and your final search

In this kind o= f big search I prefer creating a table at each step and search in the new t= able, its all in RAM so it goes preaty fast.

I hop= e this helps
Lawrence


2017-11-11 1:34 GMT+01:0= 0 Stuart Tremain <webdna@idfk.com.au>:
Hi=C2=A0


Any idea why this search will not sort ?

[SEARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-N= AMEdata=3D[SEARCH-FOR][!]
[/!]&IT-NAMEword=3Dww[!]
=
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&= IT-SHORTDESCword=3Dww[!]
[/!]&woIT-LONGDESCdata=3D[SEARC= H-FOR][!]
[/!]&IT-LONGDESCword=3Dww[!]
[/!]&deI= T-PRICEsort=3D1[!]
[/!]&IT-PRICEtype=3Dnum[!]
[/!]&= amp;max=3D100]



<= div>
Kind regards

Stuart Tremain
Pha= roah Lane Software
AUSTRALIA






--------------------------------------------------------- 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 --001a114e51909fd669055db23051-- . 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)
1314 --001a114e51909fd669055db23051 Content-Type: text/plain; charset="UTF-8" Hi Stuart, What result do you get when you put a [numfound]? Have you tried step by step? [SEARCH db=admin/data/items.db[!] [/!]&woIT-NAMEdata=[SEARCH-FOR][!] [/!]&IT-NAMEword=ww[!] [/!]&max=100] then [SEARCH db=admin/data/items.db[!] [/!]&woIT-NAMEdata=[SEARCH-FOR][!] [/!]&IT-NAMEword=ww[!] [/!]&woIT-SHORTDESCdata=[SEARCH-FOR][!] [/!]&IT-SHORTDESCword=ww[!] [/!]&max=100] and your final search In this kind of big search I prefer creating a table at each step and search in the new table, its all in RAM so it goes preaty fast. I hope this helps Lawrence 2017-11-11 1:34 GMT+01:00 Stuart Tremain : > 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 --001a114e51909fd669055db23051 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Stuart,
What result do you get when = you put a [numfound]?
Have you tried step by step?

[SE= ARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH= -FOR][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&max= =3D100]
then
[SEARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-NAMEdata=3D[SEARCH-FOR][!]
[/!]&I= T-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR= ][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&max=3D1= 00]
and your final search

In this kind o= f big search I prefer creating a table at each step and search in the new t= able, its all in RAM so it goes preaty fast.

I hop= e this helps
Lawrence


2017-11-11 1:34 GMT+01:0= 0 Stuart Tremain <webdna@idfk.com.au>:
Hi=C2=A0


Any idea why this search will not sort ?

[SEARCH db=3Dadmin/data/items.db[!]
[/!]&woIT-N= AMEdata=3D[SEARCH-FOR][!]
[/!]&IT-NAMEword=3Dww[!]
=
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&= IT-SHORTDESCword=3Dww[!]
[/!]&woIT-LONGDESCdata=3D[SEARC= H-FOR][!]
[/!]&IT-LONGDESCword=3Dww[!]
[/!]&deI= T-PRICEsort=3D1[!]
[/!]&IT-PRICEtype=3Dnum[!]
[/!]&= amp;max=3D100]



<= div>
Kind regards

Stuart Tremain
Pha= roah Lane Software
AUSTRALIA






--------------------------------------------------------- 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 --001a114e51909fd669055db23051-- . Lawrence Banahan

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:

emailer (1997) WebCat2: Items xx to xx shown, etc. (1997) Default admin bug and how tech support reacted to it. (2000) Help on how to store calculated value (2002) [delete .. &max=] (2004) Troubles with Selection Drop Down List Search (1998) WebCatalog Help (2002) Navigator 4.0 & tables (1997) blank page from template (1997) Initiating NewCart (1997) There's a bug in the math context ... (1997) using showpage and showcart commands (1996) Disappearing pid (2004) feature request-- [epoch] (2004) [WebDNA] Search using CL (2017) Anyone on OSX updated to iTools 5.018? (2000) Getting the domain of every request ... (2003) [OT] md5 or sha-1 on OSX (2007) Possible Bug in 2.0b15.acgi (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)