Re: Search Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 51383
interpreted = N
texte = Hm, well this is straight out of the docs and totally untested, but this might be it: [search db=cares.db&wnWHEELSdatarq=Packages] wn = word not equal to - this should exclude any records containing "Package", regardless of its position in the string This might narrow it down: [search db=cares.db&wnWHEELSdatarq=Packages&WHEELSword=sw] sw = start of word - this should only pick out records with "Package" at the beginning of the string Too busy to test here, let us know how it works. :-) >Doh! Thanks Daryl, > >Perhaps I need to explain a little better. > >I need to look for wheels that don't have "Packages" in the name. We >have several types of wheel "models" that start with the work >"Packages", but the rest of the field has different words in it. The >root problem is a poorly constructed database, but it's what I have >to work with until I can re-organize it. >Is there a context for something like "Doesn't start with"? > >Tom > >>Would this not do it? > >>[search >>db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004] > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search question (frank@cwolfe.com 2013)
  2. Re: [WebDNA] Search question ("Terry Wilson" 2013)
  3. RE: [WebDNA] Search question ("Terry Nair" 2013)
  4. Re: [WebDNA] Search question (Lawrence Banahan 2013)
  5. [WebDNA] Search question (frank@cwolfe.com 2013)
  6. Re: [WebDNA] Search question (Steve Craig 2012)
  7. Re: [WebDNA] Search question (Toby Cox 2012)
  8. Re: [WebDNA] Search question (Steve Craig 2012)
  9. Re: [WebDNA] Search question (Steve Craig 2012)
  10. Re: [WebDNA] Search question (Toby Cox 2012)
  11. [WebDNA] Search question (Steve Craig 2012)
  12. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  13. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  14. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  15. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Kenneth Grome 2011)
  16. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  18. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (christophe.billiottet@webdna.us 2011)
  20. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Govinda 2011)
  21. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Donovan Brooke 2011)
  22. Re: [WebDNA] SEARCH question - SHOWIF - HIDEIF question (Steve Raslevich -Northern Sound 2011)
  23. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  24. Re: [WebDNA] SEARCH question (Kenneth Grome 2011)
  25. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  26. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  27. Re: [WebDNA] SEARCH question (Govinda 2011)
  28. Re: [WebDNA] SEARCH question (Donovan Brooke 2011)
  29. Re: [WebDNA] SEARCH question (christophe.billiottet@webdna.us 2011)
  30. Re: [WebDNA] SEARCH question (Stuart Tremain 2011)
  31. Re: [WebDNA] SEARCH question (Steve Raslevich 2011)
  32. [WebDNA] SEARCH question (Stuart Tremain 2011)
  33. Re: [WebDNA] Search Question (Tony Miller 2009)
  34. Re: [WebDNA] Search Question (John Butler 2009)
  35. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  36. Re: [WebDNA] Search Question (Tony Miller 2009)
  37. Re: [WebDNA] Search Question ( 2009)
  38. Re: [WebDNA] Search Question (Tony Miller 2009)
  39. Re: [WebDNA] Search Question (Kenneth Grome 2009)
  40. Re: [WebDNA] Search Question ( 2009)
  41. [WebDNA] Search Question (Tony Miller 2009)
  42. Search question with a lookup (3 dbs) ( Palle Bo Nielsen 2004)
  43. Re: Another Search Question ( Donovan Brooke 2003)
  44. Re: Another Search Question ( Gary Krockover 2003)
  45. Re: Another Search Question ( Donovan Brooke 2003)
  46. Re: Another Search Question ( Tim Robinson 2003)
  47. Another Search Question ( Donovan Brooke 2003)
  48. Re: Search Question ( "Alain Russell" 2003)
  49. Search Question ( Jesse Proudman 2003)
  50. Re: Search Question ( Jesse Proudman 2003)
  51. Re: Search Question ( "Dan Strong" 2003)
  52. Re: Search Question ( Mark Derrick 2003)
  53. Search Question ( Jesse Proudman 2003)
  54. Re: Search Question ( 2003)
  55. Re: Search Question ( Daryl Mitchell 2003)
  56. Re: Search Question ( 2003)
  57. Re: Search Question ( Daryl Mitchell 2003)
  58. Search Question ( 2003)
  59. Re: Search Question (Matthew A Perosi 2003)
  60. Re: Search Question (Kimberly D. Walls 2003)
  61. Re: search question (Dale Therio 2001)
  62. Re: search question (Dale Therio 2001)
  63. Re: search question (Vincent Medina 2001)
  64. Re: search question (Dale Therio 2001)
  65. Re: search question (Christer Olsson 2001)
  66. Re: search question (Rob Marquardt 2001)
  67. Re: search question (Dale Therio 2001)
  68. Re: search question (Anup Setty 2001)
  69. Re: search question (Vincent Medina 2001)
  70. Re: search question (Dale Therio 2001)
  71. Re: search question (Anup Setty 2001)
  72. Re: search question (John Peacock 2001)
  73. Re: search question (Dale Therio 2001)
  74. Re: search question (Jimmi Kristensen 2001)
  75. Re: Newbie search question (between two dates) (Kenneth Grome 2001)
  76. Re: Newbie search question (between two dates) (Clint Davis 2001)
  77. Re: Newbie search question (between two dates) (Matthew Bohne 2001)
  78. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  79. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  80. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  81. Re: Newbie search question (between two dates) (Brian Fries 2001)
  82. Re: Newbie search question (between two dates) (Brian Fries 2001)
  83. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  84. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  85. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  86. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  87. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  88. Newbie search question (between two dates) (Matthew Bohne 2001)
  89. Re: Search Question (John Butler 2000)
  90. Re: Search Question (Mark Derrick 2000)
  91. Re: Search Question (John Butler 2000)
  92. Re: Search Question (Alex Cheparev 2000)
  93. Re: Search Question (Mark Derrick 2000)
  94. Re: Search Question (Kim Ingram 2000)
  95. Re: Search Question (Paul Fowler 2000)
  96. Re: Search Question (Kim Ingram 2000)
  97. Re: Search Question (Nathaniel Hadley 2000)
  98. Re: Search Question (Jason Tyler 2000)
  99. Re: Search Questions (Brady J. Horenstein 2000)
  100. Re: Search Questions (PCS Technical Support 2000)
  101. Re: Search Questions (Bob Minor 2000)
  102. Re: Search Questions (Kenneth Grome 2000)
  103. Re: Search Questions (Paul Fowler 2000)
  104. Re: Search question (Kenneth Grome 1999)
  105. Re: Newbie - Search question (Julian Clayton 1998)
  106. Re: Newbie - Search question (Mícheál O Sé 1998)
  107. Newbie - Search question (Nitai 1998)
  108. Re: Another search question please... (PCS Technical Support 1998)
  109. Another search question please... (Scott Szretter 1998)
  110. Re: Forms Search Questions (Grant Hulbert 1997)
  111. Re: Forms Search Questions (Kenneth Grome 1997)
  112. Re: Forms Search Questions (Jacques VERNAY 1997)
  113. Re: Forms Search Questions (Christer Olsson 1997)
  114. Re: Forms Search Questions (Christer Olsson 1997)
  115. Re: Forms Search Questions (Kenneth Grome 1997)
  116. Forms Search Questions (Richard Shapiro 1997)
Hm, well this is straight out of the docs and totally untested, but this might be it: [search db=cares.db&wnWHEELSdatarq=Packages] wn = word not equal to - this should exclude any records containing "Package", regardless of its position in the string This might narrow it down: [search db=cares.db&wnWHEELSdatarq=Packages&WHEELSword=sw] sw = start of word - this should only pick out records with "Package" at the beginning of the string Too busy to test here, let us know how it works. :-) >Doh! Thanks Daryl, > >Perhaps I need to explain a little better. > >I need to look for wheels that don't have "Packages" in the name. We >have several types of wheel "models" that start with the work >"Packages", but the rest of the field has different words in it. The >root problem is a poorly constructed database, but it's what I have >to work with until I can re-organize it. >Is there a context for something like "Doesn't start with"? > >Tom > >>Would this not do it? > >>[search >>db=cars.db&eqMAKEdatarq=Honda&eqMODELdatarq=Accord&neYEARdatarq=2004] > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/ ------------------------------------------------------------- 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://webdna.smithmicro.com/ Daryl Mitchell

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:

Denying access by IP address (2000) Need relative path explanation (1997) Smart caching problems with 2.1b3? (1997) So when do we get something similar? (1998) [Announce]: Web server security and password protection (1997) Re:2nd WebCatalog2 Feature Request (1996) Central Reservation System? (2003) DomainList (2005) processing .html pages (2001) How to best sort in a pre-defined item-by-item order ... (2003) Not really WebCat- (1997) Email SMTP Error 411 (2006) merchant accts. (1997) [shell]? (2000) changing order number (1998) PSC recommends what date format yr 2000??? (1997) Allow-Deny: Solved with [Getchars] (1998) [isfile] ? (1997) Strange search... (2000) WebDNA - fun to compare (2005)