Re: Sorting problem

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41424
interpreted = N
texte = That worked perfect Brian, thank you guys very much for helping me out.DonOn 7/10/02 10:21 PM, Brian Fries wrote:> In order to get the TDC.db search to sort all items you're trying to > list, you've got to find all the items with only one call to the > [search] context. Instead of nesting your searches, first search the > PrinterDB.db and build a list of all the cartridges you want into a > text variable, then search the TDC.db matching all cartridges in the > list. Something like this: > > [text]cartList=[/text][!]intialize list to be empty[/!] > [search > db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[CARTRIDGES > ]][foundItems] > [text]cartList=[cartList]+[CARTRIDGES][/text] > [/founditems] > [/search] > > [search > db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPar > tNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]] > [foundItems] > [sortorder] [title]
> [/foundItems] > [/search]
-- ************************************************************ 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:

    
  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)
That worked perfect Brian, thank you guys very much for helping me out.DonOn 7/10/02 10:21 PM, Brian Fries wrote:> In order to get the TDC.db search to sort all items you're trying to > list, you've got to find all the items with only one call to the > [search] context. Instead of nesting your searches, first search the > PrinterDB.db and build a list of all the cartridges you want into a > text variable, then search the TDC.db matching all cartridges in the > list. Something like this: > > [text]cartList=[/text][!]intialize list to be empty[/!] > [search > db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[CARTRIDGES > ]][founditems] > [text]cartList=[cartList]+[CARTRIDGES][/text] > [/founditems] > [/search] > > [search > db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPar > tNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]] > [founditems] > [sortorder] [title]
> [/foundItems] > [/search]
-- ************************************************************ 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:

Formating found categories (1997) WebCat2final1 crashes (1997) WebCat2b13MacPlugIn - more [date] problems (1997) 2.0Beta Command Ref (can't find this instruction) (1997) TCPConnect & TCPSend (2003) Cart Creation (1998) syntax question, not in online refernce (1997) Webstar 1.3.1 PPC (1997) [protect] (2000) Good vs. Bad; also [setHeader] (2002) Caching pages...again (2001) Striping Characters (1998) Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) bye bye tax rate (1998) [SearchString] problem with [search] context (1997) Stopping bad HTML propagation ? (1997) [WebDNA] max in a search (2009) multiple databases (1997) converting tabs (1997) WebCat2: multiple currency support (1997)