Re: Sorting problem

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41426
interpreted = N
texte = This specifies that only whole words should be checked in the comparison. Say you've got a part number of 123 and another one of 01234 -- if you didn't have the ...word=ww item in the search string, then doing a wo (word or) search for 123 would find both of these part numbers, since they both contain 123. See the docs under Searching / Word Breaks.- brianAt 8:19 AM 7/11/02, Don wrote: >There is one part of this code that I don't understand though, what is the >&ManufacturerPartNumberword=ww for ?? > >Don > > > >On 7/11/02 8:14 AM, Don wrote: > >> That worked perfect Brian, thank you guys very much for helping me out. >> >> Don >> >> On 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=[CARTRIDGE>> >S >>> ]][foundItems] >>> [text]cartList=[cartList]+[CARTRIDGES][/text] >>> [/founditems] >>> [/search] >>> >>> [search >>> >db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPa>> >r >>> >tNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]>> >] >>> [foundItems] >>> [sortorder] [title]
>>> [/foundItems] >>> [/search]
> >-- >************************************************************ > 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 >************************************************************-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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)
This specifies that only whole words should be checked in the comparison. Say you've got a part number of 123 and another one of 01234 -- if you didn't have the ...word=ww item in the search string, then doing a wo (word or) search for 123 would find both of these part numbers, since they both contain 123. See the docs under Searching / Word Breaks.- brianAt 8:19 AM 7/11/02, Don wrote: >There is one part of this code that I don't understand though, what is the >&ManufacturerPartNumberword=ww for ?? > >Don > > > >On 7/11/02 8:14 AM, Don wrote: > >> That worked perfect Brian, thank you guys very much for helping me out. >> >> Don >> >> On 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=[CARTRIDGE>> >S >>> ]][founditems] >>> [text]cartList=[cartList]+[CARTRIDGES][/text] >>> [/founditems] >>> [/search] >>> >>> [search >>> >db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPa>> >r >>> >tNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]>> >] >>> [founditems] >>> [sortorder] [title]
>>> [/foundItems] >>> [/search]
> >-- >************************************************************ > 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 >************************************************************-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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:

Highlighting words found in a keyword search (2003) WCS Newbie question (1997) proper way to check if a container is empty? (2000) [WebDNA] Styling search results [using css] (2009) Reversed words (1997) Mail Server Needed. (1998) Re:Emailer and encryption (1997) [WebDNA] Versions (2014) SET (1998) Week # problem (1998) Re:no [search] with NT (1997) [WebDNA] HTTP Streaming - POSSIBLE! (2010) Two submit buttons ? (1997) Bug in 4.5 - Needs to be fixed ASAP. (2002) Undeliverable Mail (1997) [OT] Domain Name Scam (2000) minimalist shopping cart. (1997) Fun with dates (1997) bug report -- leading < character (1998) Fwd: Problems with Webcatalog Plug-in (1997)