Re: Sorting problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41417
interpreted = N
texte = KenI'm not trying to sort the outer search only the inner one. The outer search goes to a printer database that tells me what cartridges that each printer uses, the inner search pulls those cartridges from our regular store database with pricing and sku numbers.Don On 7/10/02 8:09 PM, Kenneth Grome
wrote:> How can you expect the outer search to be sorted properly when you're > not even using a sort parameter in the outer search? > >> They are sorting properly in each set so if it >> out side search finds 3 items and each of those have 2 records it will sort >> each set of 2 properly but it will not sort them all together, I tried >> adding allhit=1 to the outside search again as well with no luck. >> >> Should I be doing a search with a lookup instead of 2 searches would that >> combine them ?? >> >> >> Don >> >>>> [search >>>> db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C >>>> ARTRIDGES]] >>>> [foundItems] >>>> >>>> [searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asS>>>> O >>>> RTORDERsort=1&max=20&startat=[url][startat][/url]] >>>> [foundItems] >>>> [sortorder] [title] >>>> [/foundItems] >>>> [/search] >>>> [/foundItems] >>>> [/search] > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- ************************************************************ Apple SpecialistDon Chatwin Phone: 800-645-2533 T.D. Curran Inc. Fax: 360-594-3987 800 Marine Drive email: don@tdcurran.com Bellingham WA 98225 Web: http://www.tdcurran.com ************************************************************ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
KenI'm not trying to sort the outer search only the inner one. The outer search goes to a printer database that tells me what cartridges that each printer uses, the inner search pulls those cartridges from our regular store database with pricing and sku numbers.Don On 7/10/02 8:09 PM, Kenneth Grome wrote:> How can you expect the outer search to be sorted properly when you're > not even using a sort parameter in the outer search? > >> They are sorting properly in each set so if it >> out side search finds 3 items and each of those have 2 records it will sort >> each set of 2 properly but it will not sort them all together, I tried >> adding allhit=1 to the outside search again as well with no luck. >> >> Should I be doing a search with a lookup instead of 2 searches would that >> combine them ?? >> >> >> Don >> >>>> [search >>>> db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C >>>> ARTRIDGES]] >>>> [founditems] >>>> >>>> [searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asS>>>> O >>>> RTORDERsort=1&max=20&startat=[url][startat][/url]] >>>> [founditems] >>>> [sortorder] [title] >>>> [/foundItems] >>>> [/search] >>>> [/foundItems] >>>> [/search] > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- ************************************************************ Apple SpecialistDon Chatwin Phone: 800-645-2533 T.D. Curran Inc. Fax: 360-594-3987 800 Marine Drive email: don@tdcurran.com Bellingham WA 98225 Web: http://www.tdcurran.com ************************************************************ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Don
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:
Multiple security dbs (1997)
ACGI processing for .html (1997)
Cold Fusion Warm and Fuzzy? (1999)
[WebDNA] COPYFILE & permissions (2020)
[WebDNA] Sending 100 mails an hour then pausing (2010)
Sami (1998)
Roundup function? (1997)
Date problems-more (1997)
WebStar Secure on other machine (1997)
[WebDNA] Sorry WebDNA server not running (2014)
How can I Add several Items into the cart at once? (1997)
A simple email page? (1999)
Replace context problem ... (1997)
BadSuffix with 2.1b3 cgi (1997)
Online reference (1997)
Confirmation emails classified as junk (2000)
same product in cart (1997)
Search returns all, not 20 (1997)
A multi-processor savvy WebCatalog? (1997)
Dubble Sku's in a Database (1999)