Re: case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29646
interpreted = N
texte = 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
Associated Messages, from the most recent to the oldest:
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
Eric Ridgley
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:
Browsername (1998)
ShowNext Command (1997)
multiple search commands (1997)
New public beta available (1997)
webcat method for waiting specific amount of time? (2000)
no global [username] or [password] displayed ... (1997)
Re1000001: Setting up shop (1997)
How To get Some Help (2003)
One more try (1997)
emailer (1997)
Help! WebCat2 bug (1997)
Format of Required fields error message (1997)
quantity minimum problem (1997)
Running 2 two WebCatalog.acgi's (1996)
file upload type restrictions? (2001)
[WebDNA] Some code inside a large loops fail ... but why? (2010)
Frames and WebCat (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Modulo function? (2000)
Secure server question (1997)