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:

Error Lob.db records error message not name (1997) possible, WebCat2.0 and checkboxes-restated (1997) RE: OK, here goes... (1997) [WebDNA] output of all non alphaNumeric characters? (2009) upgrade? (1997) [random] only for 1-100??? (1997) Snake Bites (1997) Cart# (1997) WebCat2: multiple currency support (1997) question: back button prevention (1997) [addlineitems] (1997) Searching two databases (2001) Country & Ship-to address & other fields ? (1997) Random sort is not random at all..... (2000) New Plug-in and Type 11 errors (1997) [WriteFile] problems (1997) oops private message leaked into talk list (1997) [WebDNA] 301 redirect (2017) Errata: WCS Newbie question (1997) [carts] and databases (1997)