Re: range search

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41300
interpreted = N
texte = >I know this is an easy one but it escapes me. I have 2 columns in my db: > >from to > >each row has a value between A and Z > >Say: > >>From to >B D >D S >A G > >I want to send one value (find) to the search context. So if find is C it >would find record 1 & 3 because C is in the range of B through D and A >through G. > >[search db=db.db&lefromdatarq=[find]&getodatarq=[find]] does not work. >This search looks ok. Does the db also contain a field for the record number?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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Strange Search Results ( Justin Carroll 2004)
  2. Re: Strange Search Results ( "Erol Guneri" 2004)
  3. Re: Strange Search Results ( Justin Carroll 2004)
  4. Re: Strange Search Results ( Glenn Busbin 2004)
  5. Re: Strange Search Results ( Justin Carroll 2004)
  6. Re: Strange Search Results ( Glenn Busbin 2004)
  7. Re: Strange Search Results ( John Peacock 2004)
  8. Re: Strange Search Results ( Justin Carroll 2004)
  9. Re: Strange Search Results ( Justin Carroll 2004)
  10. Re: Strange Search Results ( "WebDna @ Inkblot Media" 2004)
  11. Re: Strange Search Results ( Justin Carroll 2004)
  12. Re: Strange Search Results ( "WebDna @ Inkblot Media" 2004)
  13. Re: Strange Search Results ( John Peacock 2004)
  14. Re: Strange Search Results ( Justin Carroll 2004)
  15. Re: Strange Search Results ( "Gary Krockover" 2004)
  16. Re: Strange Search Results ( Justin Carroll 2004)
  17. Re: Strange Search Results ( Justin Carroll 2004)
  18. Re: Strange Search Results ( Kenneth Grome 2004)
  19. Re: Strange Search Results ( "Matthew C. Bohne" 2004)
  20. Re: Strange Search Results ( Justin Carroll 2004)
  21. Strange Search Results ( Justin Carroll 2004)
  22. Strange search/writefile issue ( devaulw@onebox.com 2004)
  23. Re: Range search ( Jesse Williams-Proudman 2003)
  24. Re: Range search ( Aaron Lynch 2003)
  25. Re: Range search ( Jesse Williams-Proudman 2003)
  26. Range search ( Aaron Lynch 2003)
  27. Re: Number/Date Range Search (Clint Davis 2003)
  28. Number/Date Range Search (Clint Davis 2003)
  29. Re: Another date range search Q (Brian Fries 2002)
  30. Re: Another date range search Q (Gary Krockover 2002)
  31. Another date range search Q (Gary Krockover 2002)
  32. Re: range search (sally 2002)
  33. Re: range search (Glenn Busbin 2002)
  34. Re: range search (marc malacarme 2002)
  35. Dates and range searches (Ken MacMurchy 2002)
  36. Re: Strange search... (Kimberly Ingram 2001)
  37. Re: Strange search... (Jimmi Kristensen 2001)
  38. Re: Strange search... (Jimmi Kristensen 2001)
  39. Re: Strange search... (Kimberly Ingram 2001)
  40. Re: Strange search... (Kimberly Ingram 2001)
  41. Re: Strange search... (Kimberly Ingram 2001)
  42. Re: Strange search... (Nitai @ ComputerOil 2001)
  43. Re: Strange search... (Jimmi Kristensen 2001)
  44. Re: Strange search... (Kenneth Grome 2001)
  45. Re: Strange search... (Alain Russell 2001)
  46. Re: Strange search... (Nitai @ ComputerOil 2001)
  47. Re: Strange search... (Aaron Lynch 2001)
  48. Strange search... (Jimmi Kristensen 2001)
  49. Re: Date Range Search not working (Kenneth Grome 2000)
  50. Date Range Search not working (Larry Orchier 2000)
  51. Re: Strange search... (Kenneth Grome 2000)
  52. Re: Strange search... (John Hill 2000)
  53. Strange search... (Jimmi Kristensen 2000)
  54. Re: range searching (Laurent Pladys 1998)
  55. Re: range searching (Laurent Pladys 1998)
  56. Re: range searching (PCS Technical Support 1998)
  57. range searching (Laurent Pladys 1998)
  58. Re: range searching (Kenneth Grome 1998)
  59. A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
  60. Re: Date Range search (Marty Schmid 1997)
  61. Date Range search (w curt eggemeyer 1997)
>I know this is an easy one but it escapes me. I have 2 columns in my db: > >from to > >each row has a value between A and Z > >Say: > >>From to >B D >D S >A G > >I want to send one value (find) to the search context. So if find is C it >would find record 1 & 3 because C is in the range of B through D and A >through G. > >[search db=db.db&lefromdatarq=[find]&getodatarq=[find]] does not work. >This search looks ok. Does the db also contain a field for the record number?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/ Glenn Busbin

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:

headers (2000) Sort Order on a page search (1997) Where's Cart Created ? (1997) [WebDNA] Integrating with WP and PHP (2011) Follow-Up to: Removing [showif] makes a big difference in speed (1997) Configuring E-mail (1997) Re:Emailer and encryption (1997) Text data with spaces in them... (1997) links to .db's ? (1999) all records returned. (1997) High ASCII inside [LOOKUP] inside [LISTWORDS] (1998) WebCatalog NT (1996) [WebDNA] TCP HTTP/1.1 questions (2011) [isfile] ? (1997) categorys (1998) Arrays (2000) RE: Error: template (1997) [defined]ish (1997) WebCatalog for guestbook ? (1997) Problems with [Search] param - Mac Plugin b15 (1997)