Re: Search bug. Help
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43560
interpreted = N
texte = Andrew Simpson wrote: > If an error is caused and occurs it must be able to be caught. I'm not > arguing the fact that coders shouldn't write bad code... I'm arguing the > fact that bad code shouldn't bring down a service. > And you are also missing my point! :( WebCatalog treats every single field as text unless you tell it otherwise by using the FIELDtype=??? parameter to the search. AND, if you do that, WebCatalog takes you at your word that the field actually contains the data you are telling it that it contains. There is no way to test for the error without massively slowing down the system:[pseudocode on] [loop on all data matching search criteria] [peek at record] [did the programmer assert column was a particular type?] [try and figure out if the type is reasonable] [print out an error message] [/loop] [/pseudocode]No, I don't want the have my searches degraded to protect people who can't keep their code clean. Yes, I am a hardass, why do you ask? ;~)When searching on fields forced to be treated as a number, WebCat does not allow the same types of searches as when searching on text. Is this a limitation? Yes. Can it be worked around? Yes. Would it be possible for WebCat to kick out an error if you tried to do a WO (that's WORD OR) search on numbers? Probably. The issue is truly that you can only do certain searches on numeric fields and WORD OR is not one of them.Johnp.s. and I have asked a few questions over the years, just not many... :~)-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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:
Andrew Simpson wrote: > If an error is caused and occurs it must be able to be caught. I'm not > arguing the fact that coders shouldn't write bad code... I'm arguing the > fact that bad code shouldn't bring down a service. > And you are also missing my point! :( WebCatalog treats every single field as text unless you tell it otherwise by using the FIELDtype=??? parameter to the search. AND, if you do that, WebCatalog takes you at your word that the field actually contains the data you are telling it that it contains. There is no way to test for the error without massively slowing down the system:[pseudocode on] [loop on all data matching search criteria] [peek at record] [did the programmer assert column was a particular type?] [try and figure out if the type is reasonable] [print out an error message] [/loop] [/pseudocode]No, I don't want the have my searches degraded to protect people who can't keep their code clean. Yes, I am a hardass, why do you ask? ;~)When searching on fields forced to be treated as a number, WebCat does not allow the same types of searches as when searching on text. Is this a limitation? Yes. Can it be worked around? Yes. Would it be possible for WebCat to kick out an error if you tried to do a WO (that's WORD OR) search on numbers? Probably. The issue is truly that you can only do certain searches on numeric fields and WORD OR is not one of them.Johnp.s. and I have asked a few questions over the years, just not many... :~)-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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/
John Peacock
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:
range searching (1998)
URL for Discussion Archive (1997)
Setting up WebCatalog with Retail Pro data (1996)
How far do [showif]s go? (1997)
WC + MYSQL + ODBC (2002)
[WebDNA] Using WebDNA with MAMP (2010)
[WebDNA] bug in sending & character to DOS (2010)
Netscape Communicator 4 chops off URLs (was No Data) (1997)
easy numfound search? (2001)
Off-Topic: Optimal WebSTAR settings for WebDNA plugin v4.5 (2002)
UPDATE PROBLEM (1997)
Navigator 4.01 (1997)
WebCatalog for guestbook ? (1997)
Surprise x and y post args (1998)
expired beta (1997)
japanese characters (1997)
Nested tags count question (1997)
Locking up with WebCatalog... (1997)
sendmail what is SIMS? (1999)
Error Page? (1997)