Re: Search bug. Help

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43488
interpreted = N
texte = I think the problem is not about multiple decimal places but more that it can't differentiate between the two values it needs to search for. Thatıs why it doesn't crash when I remove the ,.It seems to me to be pretty basic to find any record who's value is either .20 or .25 exactly not 1.20 or 1.25. > I do know that WebCat does some strange stuff when you tell it to sort on a > type=num when the number contains more than one decimal place. This may be a > related problem. > > If the archives are up, have a look in there for multiple decimal place > problem and see how they fixed it. > > ----- Original Message ----- > From: marc malacarme > To: WebCatalog Talk > Sent: Wednesday, September 18, 2002 8:29 AM > Subject: Re: Search bug. Help > > >> If I use [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20 .25&CTword=ww] >> only then when I search for 1.20 I get .20 as a valid result. >> >>> How about? >>> >>> [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20 .25&CTword=ww] >>> >>> >>> >>> Brian >>> >>> -----Original Message----- >>> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf >>> Of marc malacarme >>> Sent: Tuesday, September 17, 2002 4:12 PM >>> To: WebCatalog Talk >>> Subject: Search bug. Help >>> >>> >>> Webcat 4.5, osx, webstar5.1 >>> >>> The following search returned mime header information to the browser and >>> then crashes webcat. >>> >>> [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20,.25,&CTtype=num] >>> >>> Mydb looks like this: >>> >>> shape ct >>> rd .20 >>> rd .25 >>> pr .50 >>> rd 1.25 >>> rd 1.20 >>> >>> When I add cttype=num it crashes but without it it finds .20 inside 1.20 >>> >>> IF I remove the , it doesn't crash but only finds the first value .20 > and >>> not .20 and .25. >>> >>> How do you tell webcat to search for multiple values ie: .20 & .25 as > whole >>> numbers. Shouldn't there be a wn like there is a ww in wordbreaks. >>> >>> Any help would be appreciated >>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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: Search bug. Help (John Peacock 2002)
  2. Re: Search bug. Help (Kenneth Grome 2002)
  3. Re: Search bug. Help (Kenneth Grome 2002)
  4. Re: Search bug. Help (Clint Davis 2002)
  5. Re: Search bug. Help (Brian Fries 2002)
  6. Re: Search bug. Help (Andrew Simpson 2002)
  7. Re: Search bug. Help (John Peacock 2002)
  8. Re: Search bug. Help (Kenneth Grome 2002)
  9. Re: Search bug. Help (marc malacarme 2002)
  10. Re: Search bug. Help (Kenneth Grome 2002)
  11. Re: Search bug. Help (Kenneth Grome 2002)
  12. Re: Search bug. Help (marc malacarme 2002)
  13. Re: Search bug. Help (marc malacarme 2002)
  14. Re: Search bug. Help (Kenneth Grome 2002)
  15. Re: Search bug. Help (Andrew Simpson 2002)
  16. Re: Search bug. Help (Kenneth Grome 2002)
  17. Re: Search bug. Help (Brian Fries 2002)
  18. Re: Search bug. Help (Rob Marquardt 2002)
  19. Re: Search bug. Help (Gary Krockover 2002)
  20. Re: Search bug. Help (Rob Marquardt 2002)
  21. Re: Search bug. Help (marc malacarme 2002)
  22. Re: Search bug. Help (marc malacarme 2002)
  23. Re: Search bug. Help (Brian Fries 2002)
  24. Re: Search bug. Help (Brian Boegershausen 2002)
  25. Re: Search bug. Help (Andrew Simpson 2002)
  26. Re: Search bug. Help (marc malacarme 2002)
  27. Re: Search bug. Help (marc malacarme 2002)
  28. Re: Search bug. Help (Glenn Busbin 2002)
  29. Re: Search bug. Help (Brian Boegershausen 2002)
  30. Search bug. Help (marc malacarme 2002)
I think the problem is not about multiple decimal places but more that it can't differentiate between the two values it needs to search for. Thatıs why it doesn't crash when I remove the ,.It seems to me to be pretty basic to find any record who's value is either .20 or .25 exactly not 1.20 or 1.25. > I do know that WebCat does some strange stuff when you tell it to sort on a > type=num when the number contains more than one decimal place. This may be a > related problem. > > If the archives are up, have a look in there for multiple decimal place > problem and see how they fixed it. > > ----- Original Message ----- > From: marc malacarme > To: WebCatalog Talk > Sent: Wednesday, September 18, 2002 8:29 AM > Subject: Re: Search bug. Help > > >> If I use [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20 .25&CTword=ww] >> only then when I search for 1.20 I get .20 as a valid result. >> >>> How about? >>> >>> [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20 .25&CTword=ww] >>> >>> >>> >>> Brian >>> >>> -----Original Message----- >>> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf >>> Of marc malacarme >>> Sent: Tuesday, September 17, 2002 4:12 PM >>> To: WebCatalog Talk >>> Subject: Search bug. Help >>> >>> >>> Webcat 4.5, osx, webstar5.1 >>> >>> The following search returned mime header information to the browser and >>> then crashes webcat. >>> >>> [search db=mydb.db&eqSHAPEdatarq=rd&woCTdatarq=.20,.25,&CTtype=num] >>> >>> Mydb looks like this: >>> >>> shape ct >>> rd .20 >>> rd .25 >>> pr .50 >>> rd 1.25 >>> rd 1.20 >>> >>> When I add cttype=num it crashes but without it it finds .20 inside 1.20 >>> >>> IF I remove the , it doesn't crash but only finds the first value .20 > and >>> not .20 and .25. >>> >>> How do you tell webcat to search for multiple values ie: .20 & .25 as > whole >>> numbers. Shouldn't there be a wn like there is a ww in wordbreaks. >>> >>> Any help would be appreciated >>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ marc malacarme

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:

Setting up WebCatalog with Retail Pro data (1996) emailer (1997) WebCat2b13MacPlugIn - [include] (1997) Rename folder under WC3 (2000) message board (2001) WC TableGrinder (1997) emailer (1997) Getting Emailer to send mail (1997) taxTotal, grandTotal (1997) Migrating to NT (1997) Practice runs ? (1997) [WebDNA] WebDNA Health Monitor (2014) easy numfound search? (2001) Price lookup problem - was Cart questions (1997) Pithy questions on webcommerce & siteedit (1997) maybe even an easier plan to satisfy need for solid tech support? (2000) [WebDNA] Is anybody running a CAPTCHA? (2017) Suffix Mapping (1998) Orders coming up blank (2004) Extra carriage returns (1999)