Re: Sorting problem

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41390
interpreted = N
texte = Are you getting multiple founditems on the outside search? If so then the founditems from the TDC.db will only be sorted WITHIN each found Printer.db record.Otherwise, try adding &allhit=1 to your search string.- brianAt 4:09 PM 7/10/02, Don wrote: >It still wont work for me here is the entire code > >[searchdb=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C >ARTRIDGES]]
>[foundItems]
>[searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asSO >RTORDERsort=1&max=20&startat=[url][startat][/url]]
>[foundItems]
>[sortorder] [title]
>[/foundItems]
>[/search]
>[/foundItems]
>[/search]
> >I'm trying to make the list sort by the field SortOrder which is a field >stored in the 2nd search DB I do this all the time when I'm only calling >from one database but it just doesn't seem to want to work when searching >from 2. > >Any Ideas > >Don > > >On 7/10/02 2:23 PM, Glenn Busbin wrote: > >> Sorry. My bad. I looked at the sorts and didn't notice that you're searching >> on 2 fields in Printer.db and had some other syntax errors. >> >> Try this: >> >> [search >>db=PrinterDB.db&eqModeldatarq=[Model]&eqCARTRIDGESdatarq=[CARTRIDGES] >> &asCARTRIDGESsort=1] >> [foundItems] >> [search db=TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]& >> asTITLEsort=1&max=20&startat=[url][startat][/url]] >> [foundItems] >> [title]
>> [/foundItems] >> [/search] >> [/foundItems] >> [/search] >> >> Glenn >> >> ------------------------------------------------------------- >> 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 Specialist > >Don 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/ ------------------------------------------------------------- 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:

    
  1. Re: Sorting Problems ( Toby Cox 2004)
  2. Re: Sorting Problems ( Brian Fries 2004)
  3. Re: Sorting Problems ( Glenn Busbin 2004)
  4. Re: Sorting Problems ( Pat Holliday 2004)
  5. Re: Sorting Problems ( Glenn Busbin 2004)
  6. Re: Sorting Problems ( Brian Fries 2004)
  7. Re: Sorting Problems ( Joe D'Andrea 2004)
  8. Re: Sorting Problems ( Gary Krockover 2004)
  9. Sorting Problems ( Pat Holliday 2004)
  10. Re: oddball sorting problem ( Terry Wilson 2003)
  11. Re: oddball sorting problem [feature request] ( Donovan Brooke 2003)
  12. Re: oddball sorting problem ( Brian Fries 2003)
  13. Re: oddball sorting problem ( Terry Wilson 2003)
  14. Re: oddball sorting problem ( Donovan Brooke 2003)
  15. oddball sorting problem -- almost okay now ( Terry Wilson 2003)
  16. Re: oddball sorting problem ( Tim Robinson 2003)
  17. Re: oddball sorting problem ( "WebDna @" 2003)
  18. oddball sorting problem ( Terry Wilson 2003)
  19. Re: Sorting problem (Don 2002)
  20. Re: Sorting problem (Don 2002)
  21. Re: Sorting problem (Brian Fries 2002)
  22. Re: Sorting problem (Don 2002)
  23. Re: Sorting problem (Don 2002)
  24. Re: Sorting problem (Anup Setty 2002)
  25. Re: Sorting problem (Kenneth Grome 2002)
  26. Re: Sorting problem (Brian Fries 2002)
  27. Re: Sorting problem (Glenn Busbin 2002)
  28. Re: Sorting problem (Don 2002)
  29. Re: Sorting problem (Don 2002)
  30. Re: Sorting problem (Kenneth Grome 2002)
  31. Re: Sorting problem (Glenn Busbin 2002)
  32. Re: Sorting problem (Don 2002)
  33. Re: Sorting problem (Gary Krockover 2002)
  34. Re: Sorting problem (Don 2002)
  35. Re: Sorting problem (Glenn Busbin 2002)
  36. Re: Sorting problem (Don 2002)
  37. Re: Sorting problem (Don 2002)
  38. Re: Sorting problem (Brian Fries 2002)
  39. Re: Sorting problem (Glenn Busbin 2002)
  40. Re: Sorting problem (Glenn Busbin 2002)
  41. Re: Sorting problem (Don 2002)
  42. Re: Sorting problem (Glenn Busbin 2002)
  43. Re: Sorting problem (Glenn Busbin 2002)
  44. Sorting problem (Don 2002)
  45. Re: Sorting problems (Kenneth Grome 2000)
  46. Sorting problems (Marc 2000)
  47. sorting problem for sku=0? (Olin Lagon 1998)
  48. Re: Sorting problem (Kenneth Grome 1997)
  49. Sorting problem (kmuelle3@ix.netcom.com 1997)
Are you getting multiple founditems on the outside search? If so then the founditems from the TDC.db will only be sorted WITHIN each found Printer.db record.Otherwise, try adding &allhit=1 to your search string.- brianAt 4:09 PM 7/10/02, Don wrote: >It still wont work for me here is the entire code > >[searchdb=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C >ARTRIDGES]]
>[founditems]
>[searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asSO >RTORDERsort=1&max=20&startat=[url][startat][/url]]
>[founditems]
>[sortorder] [title]
>[/foundItems]
>[/search]
>[/foundItems]
>[/search]
> >I'm trying to make the list sort by the field SortOrder which is a field >stored in the 2nd search DB I do this all the time when I'm only calling >from one database but it just doesn't seem to want to work when searching >from 2. > >Any Ideas > >Don > > >On 7/10/02 2:23 PM, Glenn Busbin wrote: > >> Sorry. My bad. I looked at the sorts and didn't notice that you're searching >> on 2 fields in Printer.db and had some other syntax errors. >> >> Try this: >> >> [search >>db=PrinterDB.db&eqModeldatarq=[Model]&eqCARTRIDGESdatarq=[CARTRIDGES] >> &asCARTRIDGESsort=1] >> [founditems] >> [search db=TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]& >> asTITLEsort=1&max=20&startat=[url][startat][/url]] >> [founditems] >> [title]
>> [/foundItems] >> [/search] >> [/foundItems] >> [/search] >> >> Glenn >> >> ------------------------------------------------------------- >> 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 Specialist > >Don 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/ ------------------------------------------------------------- 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/ Brian Fries

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:

WebCat2b15MacPlugin - [protect] (1997) Break out of a loop? (2000) Associative lookup style? + bit more (1997) FEW QUESTIONS (1997) Multiply prices (1997) How many lookups does it take ... (2003) Protect and Serve (1999) Middle Context (2002) A question on sub-categories (1997) Bad cookie (1998) OT: Weird table rendering w/ WebCat in Explorer (2005) NT 2.1b10 (1998) [OT] What log analyzer do you use? (2000) 'does not contain' operator needed ... (1997) More questions about serial number dishing (1997) Simple way to create unique SKU (1997) WC 2.0 frames feature (1997) [WebDNA] two ideas for running a cluster of WebDNA servers (2019) possible, WebCat2.0 and checkboxes-restated (1997) WebCat.acgi from /cgi-bin/? (1997)