Re: [WebDNA] Search not sorting

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113722
interpreted = N
texte = 1317 --Apple-Mail=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Lawrence All expected results ([NUMFOUND]) are returned, I will give your = suggestions go. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 11 Nov 2017, at 21:06, Lawrence Banahan = wrote: >=20 > Hi Stuart, > What result do you get when you put a [numfound]? > Have you tried step by step? >=20 > [SEARCH 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][!] > [/!]&IT-NAMEword=3Dww[!] > [/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!] > [/!]&IT-SHORTDESCword=3Dww[!] > [/!]&max=3D100] > and your final search >=20 > 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. >=20 > I hope this helps > Lawrence >=20 >=20 > 2017-11-11 1:34 GMT+01:00 Stuart Tremain >: > Hi=20 >=20 >=20 > Any idea why this search will not sort ? >=20 > [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] >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=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 --Apple-Mail=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Lawrence

All expected results ([NUMFOUND]) are returned, I will give = your suggestions go.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 11 Nov 2017, at 21:06, Lawrence Banahan <banahan.l@gmail.com>= wrote:

Hi Stuart,
What result do you get when you put a [numfound]?
Have you tried step by step?

[SEARCH 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][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&max=3D100]
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 <webdna@idfk.com.au>:
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






--------------------------------------------------------- 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=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B-- . 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)
1317 --Apple-Mail=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi Lawrence All expected results ([NUMFOUND]) are returned, I will give your = suggestions go. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 11 Nov 2017, at 21:06, Lawrence Banahan = wrote: >=20 > Hi Stuart, > What result do you get when you put a [numfound]? > Have you tried step by step? >=20 > [SEARCH 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][!] > [/!]&IT-NAMEword=3Dww[!] > [/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!] > [/!]&IT-SHORTDESCword=3Dww[!] > [/!]&max=3D100] > and your final search >=20 > 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. >=20 > I hope this helps > Lawrence >=20 >=20 > 2017-11-11 1:34 GMT+01:00 Stuart Tremain >: > Hi=20 >=20 >=20 > Any idea why this search will not sort ? >=20 > [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] >=20 >=20 >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=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 --Apple-Mail=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Hi Lawrence

All expected results ([NUMFOUND]) are returned, I will give = your suggestions go.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






On 11 Nov 2017, at 21:06, Lawrence Banahan <banahan.l@gmail.com>= wrote:

Hi Stuart,
What result do you get when you put a [numfound]?
Have you tried step by step?

[SEARCH 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][!]
[/!]&IT-NAMEword=3Dww[!]
[/!]&woIT-SHORTDESCdata=3D[SEARCH-FOR][!]
[/!]&IT-SHORTDESCword=3Dww[!]
[/!]&max=3D100]
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 <webdna@idfk.com.au>:
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






--------------------------------------------------------- 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=_986ACF13-F7AB-4A38-9AD8-C26C2A63C39B-- . 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:

append=T problem (1998) Protect (1997) Weird NT mail (1998) Return records from another (1997) WebMerchant setup (1998) Selling? (2001) Some Questions (1997) OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998) &fieldsdir=ra truely random?? (2000) Opinion: [input] should be called [output] ... (1997) Does [Sendmail] create html? (2002) Mail Server Needed. (1998) Help! WebCat2 bug (1997) Caching [include] files ... (1997) [OT] JS snippet needed (2006) How does 4DWebSTAR V's cache work? (2002) Scope of variables in multi include files (2000) details (2003) Configuring E-mail (1997) WebCat for mass emailings (1997)