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:

Page Breaks (1999) using showpage and showcart commands (1996) Summing fields (1997) Re:trouble (1997) Spiders and Bots (2000) Problem (1997) How To question on setting up downloads (1997) I'm new be kind (1997) sorting and summarizing (1998) [WebDNA] WebDNA future (2010) [WebDNA] Yosemite (2015) Moment of Thanks (1997) Everyone: List Traffic (was [include ...] behavior) (1997) carriage returns in data (1997) WebCatb15 Mac CGI -- [purchase] (1997) [showif] / [hideif] (1997) information on Vieworders.tpl (1998) wierd [cart] action! (1997) [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (2009) WebDNA won't start on reboot (2003)