Re: case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29648
interpreted = N
texte = Please provide the search code, db field names and db field values that don't work the way you expect them to, and one of us will explain how to do it correctly.>I read the docs. The docs say you can search on a range of values that are >text. I found that if the field contains spaces in the text I am searching >it was returning ALL the fields because it 'appeared' to be performing a >word 'OR' search using the space as the default word delimiter. I wanted >WebCat to look at WHOLE value of the field, not part. That was my problem, >the range on a text value was not working if the values of the fields >contained spaces. > >I also found in the pdf docs an example in searching a range of numbers that >you separate the two values with a '+' but the online docs use a space ' '. > >I wanted to return case numbers '00 F 700' to '00 G 714'. > >> From: Kenneth Grome
>> Reply-To: (WebCatalog Talk) >> Date: Mon, 27 Mar 2000 09:38:37 -1000 >> To: (WebCatalog Talk) >> Subject: Re: case number with spaces. >> >>>>> Any Ideas or should I just add a few more fields in FMP that 'dismantle' >>>>> the >>>>> serial number? >>>> >>>> Yes, you will have to do this ... >>> >>> this is one of those little pain in the butt things I've come to dislike >>> about WebCat. Generally I think WebCat is great! I do think that it is a >>> fantastic product for creating dynamic web content but these little 'pit >>> falls' tend to get annoying. Especially because everything I want to do with >>> this problem can 'be declared' but it seems when you do a range of values >>> you can't tell it to look at the spaces as values instead of word breaks. >> >> Eric, you cannot declare this type of search in webcatalog, so I think you >> are misunderstanding the webdna language/syntax when it comes to performing >> this kind of search. Try reading the HTML docs again to better understand what >> you can and cannot declare. >> >> The reason for different database fields in the first place is to define the >> *entire value* which will be compared in your searches. Nowhere in the docs >> does it suggest that you can perform a comparison on PART of a database field >> value. Therefore, you must put the part you wish to compare into a new field, >> then do your comparison against the full value of the new field. This is just >> how it's done, not only in webcatalog but in all other database software as >> well ... >> >> ================================ >> Kenneth Grome, WebDNA Consultant >> 808-737-6499 http://webdna.net >> ================================ >> >> >> >> >> >> ------------------------------------------------------------- >> 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 >> > > >------------------------------------------------------------- >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 ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
Please provide the search code, db field names and db field values that don't work the way you expect them to, and one of us will explain how to do it correctly.>I read the docs. The docs say you can search on a range of values that are >text. I found that if the field contains spaces in the text I am searching >it was returning ALL the fields because it 'appeared' to be performing a >word 'OR' search using the space as the default word delimiter. I wanted >WebCat to look at WHOLE value of the field, not part. That was my problem, >the range on a text value was not working if the values of the fields >contained spaces. > >I also found in the pdf docs an example in searching a range of numbers that >you separate the two values with a '+' but the online docs use a space ' '. > >I wanted to return case numbers '00 F 700' to '00 G 714'. > >> From: Kenneth Grome >> Reply-To: (WebCatalog Talk) >> Date: Mon, 27 Mar 2000 09:38:37 -1000 >> To: (WebCatalog Talk) >> Subject: Re: case number with spaces. >> >>>>> Any Ideas or should I just add a few more fields in FMP that 'dismantle' >>>>> the >>>>> serial number? >>>> >>>> Yes, you will have to do this ... >>> >>> this is one of those little pain in the butt things I've come to dislike >>> about WebCat. Generally I think WebCat is great! I do think that it is a >>> fantastic product for creating dynamic web content but these little 'pit >>> falls' tend to get annoying. Especially because everything I want to do with >>> this problem can 'be declared' but it seems when you do a range of values >>> you can't tell it to look at the spaces as values instead of word breaks. >> >> Eric, you cannot declare this type of search in webcatalog, so I think you >> are misunderstanding the webdna language/syntax when it comes to performing >> this kind of search. Try reading the HTML docs again to better understand what >> you can and cannot declare. >> >> The reason for different database fields in the first place is to define the >> *entire value* which will be compared in your searches. Nowhere in the docs >> does it suggest that you can perform a comparison on PART of a database field >> value. Therefore, you must put the part you wish to compare into a new field, >> then do your comparison against the full value of the new field. This is just >> how it's done, not only in webcatalog but in all other database software as >> well ... >> >> ================================ >> Kenneth Grome, WebDNA Consultant >> 808-737-6499 http://webdna.net >> ================================ >> >> >> >> >> >> ------------------------------------------------------------- >> 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 >> > > >------------------------------------------------------------- >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 ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Kenneth Grome
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:
Re:Navigator 4.01 (1997)
WebCatalog can't find database (1997)
[SearchString] problem with [search] context (1997)
[WebDNA] encrypting more than just a credit card number.... (2014)
WebCatalog can't find database (1997)
Converting order file to database (1998)
wo search help (1999)
HELP!!! (1998)
resorting found set (2005)
StoreBuilder and PayPal (2002)
WebCat: Paying affiliates commissions?? (2000)
Emailer Timing out (1999)
Feature Request [TABLE ... &delimiters=] (2007)
multi-paragraph fields (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WebCat2: Items xx to xx shown, etc. (1997)
emailer setup (1997)
[BoldWords] WebCat.acgib15Mac (1997)
$Quit, $CloseDatabase corrections (1997)
docs for WebCatalog2 (1997)