Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56046
interpreted = N
texte = I completely understood that I wouldn't be getting an exact solution. I = think those that did respond understood my situation and they have done = alot to help me. It was my misunderstanding of how [search] handles text = when it's searching with a data type of num that created my problem in the = first place. Obviously you haven't checked out the page I posted or you'd know that we'= re not dealing with dates here. We're dealing with numbers. The database = header end_date held a date turned into a number. Justin Carroll On Thursday, April 1, 1943, Glenn Busbin wrote: >>I apologize. I'm not authorized to give you my exact code. I >did post a test though that shows the same thing I'm running up >against. > > >If you can't post the exact code, don't expect an exact >solution. > >There's no bug in WC that will foul up the search results, but >bugs in your database or code will. > >If your code is good, then your database is screwed up. Zero is >not a date. Never was. Never will be. If you have to resort to >some "workaround", you're asking for trouble. Either your code >works with your data 100% of the time or it's a time bomb >waiting to go off. A 99.99% success rate is no better, and >probably worse, than a 0.01% success rate. > >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://webdna.smithmicro.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://webdna.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)
I completely understood that I wouldn't be getting an exact solution. I = think those that did respond understood my situation and they have done = alot to help me. It was my misunderstanding of how [search] handles text = when it's searching with a data type of num that created my problem in the = first place. Obviously you haven't checked out the page I posted or you'd know that we'= re not dealing with dates here. We're dealing with numbers. The database = header end_date held a date turned into a number. Justin Carroll On Thursday, April 1, 1943, Glenn Busbin wrote: >>I apologize. I'm not authorized to give you my exact code. I >did post a test though that shows the same thing I'm running up >against. > > >If you can't post the exact code, don't expect an exact >solution. > >There's no bug in WC that will foul up the search results, but >bugs in your database or code will. > >If your code is good, then your database is screwed up. Zero is >not a date. Never was. Never will be. If you have to resort to >some "workaround", you're asking for trouble. Either your code >works with your data 100% of the time or it's a time bomb >waiting to go off. A 99.99% success rate is no better, and >probably worse, than a 0.01% success rate. > >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://webdna.smithmicro.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://webdna.smithmicro.com/ Justin Carroll

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:

japanese characters (1997) Forms Search Questions (1997) [OT] Templates (For Sale) sites (2004) NT Version on IIS 4.0 (1997) Sort Order on a page search (1997) Directory Overload (1998) Frames and WebCat (1997) OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998) funky character (2002) FEA REQ: One .hdr, multiple .db's (2003) Record Modified Date - SQL ? (2000) Applying discounts as more items are added... (1997) RE: WebCatalog NT beta 18 now available (1997) Hiding URL ? (1998) Sense/Disallow HTML tags during $Append (1997) FEW QUESTIONS (1997) include bug????? (1997) HELP! 10K hits per hour for pages that no longer exist! (2000) Re:Running 2 two WebCatalog.acgi's (1996) Draft Manual, Tutorial, and more (1997)