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 CarrollOn 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:
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 CarrollOn 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)