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:
WebCatalog can't find database (1997)
Help formatting search results w/ table (1997)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
2nd WebCatalog2 Feature Request (1996)
WebCatalog on Windows 98 (2000)
WC2f3 (1997)
Sorting by SKU Not Working (1998)
Bug? (1997)
% (mod) was looping table rows (1999)
japanese characters (1997)
Another Excel Problem (2003)
[protect admin] (1997)
SSL do I need it?? (1998)
talk lists down - email question (2002)
Next X hits (1996)
File Upload (1997)
!!!! WebCat Programmer Opening for Growth eCommerce Startup!!!! (1999)
ShowIf helper? (1998)
Overseas project (2000)
'bot Q (2000)