Re: Search bug. Help
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43494
interpreted = N
texte = You cannot use the type=num with multiple values - WebDNA will try to convert the multiple values into a single number, as though you did a [math].20 .25[/math], which will essentially truncate the value at the first non-numeric / non-decimal character.Leave out the type=num and the let the comparisons be done as text.- brianAt 1:44 PM 9/17/02, marc malacarme wrote: >I though CTwbrk= described the data in the database? > >In any case I only get the first value returned .20 using the search below > >[search db=loose-dia.db&woCTdatarq=.20, .25&CTword=ww&CTwbrk=, &CTtype=num] > > >> Try adding &CTwbrk=, (comma and space) to your search. >> >> - brian >> >> At 1:29 PM 9/17/02, marc malacarme wrote: >>> 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/
Associated Messages, from the most recent to the oldest:
You cannot use the type=num with multiple values - WebDNA will try to convert the multiple values into a single number, as though you did a [math].20 .25[/math], which will essentially truncate the value at the first non-numeric / non-decimal character.Leave out the type=num and the let the comparisons be done as text.- brianAt 1:44 PM 9/17/02, marc malacarme wrote: >I though CTwbrk= described the data in the database? > >In any case I only get the first value returned .20 using the search below > >[search db=loose-dia.db&woCTdatarq=.20, .25&CTword=ww&CTwbrk=, &CTtype=num] > > >> Try adding &CTwbrk=, (comma and space) to your search. >> >> - brian >> >> At 1:29 PM 9/17/02, marc malacarme wrote: >>> 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/
Brian Fries
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:
Nitro plugin? (1998)
[WebDNA] Poll: Discussion Forum (2009)
Help formatting search results w/ table (1997)
automating txt downloads for conversion to webcat db (2006)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
I'm tired of all this! (2000)
Database Updates (1997)
[format xs] freeze (1997)
New Web Site Developers Database (1996)
unitshipcost vs shipcosts (1997)
WebCatalog for Postcards ? (1997)
[WebDNA] WebDNA7 site randomly dropping tags (2011)
Not really WebCat- (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Support ?? (1997)
List Name Change (2002)
The Guru Speaks-very long reply (1998)
Server IP address? (1998)
Webmerch Error (1998)
page redirect in webDNA (1997)