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:

Ampersand Character (&) (1997) [WebDNA] WebDNA7 url plus get? (2011) Template Encryption (1998) createfolder not behaving as expected (1999) WebCatalog stalls (1998) japanese characters (1997) test (1998) WebCat editing, SiteGuard & SiteEdit (1997) Can webcat 3.0/4.0 handle 1,000,000 hits a day? (2000) Multi-processor Mac info ... (1997) Help name our technology! I found it (1997) Pre-flight public flag (1997) &max= (2003) mac os HOG? (2001) NT Manual (1997) Exclamation point (1997) passing user info on each page (2000) chicken / egg::purchase / setheader (2002) Looking up two prices in database? (1997) Blocking off access (2005)