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:

version 2 for NT (1997) groupfields .. again... (2000) Upgrading old WebCat Database Files (1997) New Command prefs ... (1997) [WebDNA] WebDNA 6.2 and Mac OS X 10.5 Client / Server ? (2009) Roundup function? (1997) Cookies and webcat (1997) Using Plug-In while running 1.6.1 (1997) [SHOWIF] PROBLEM (2000) What file? (1997) WebCatalog can't find database (1997) How can I record purchases to a database? (1998) anyone integrated inventory w/ storebuilder? (2003) wish list (2002) Multiple cart additions (1997) Separate SSL Server (1997) WC Database Format (1997) flushdatabases (2000) [WebDNA] fastcgi 7+ & [cart]? (2010) WCS Newbie question (1997)