Re: case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29645
interpreted = N
texte = >>> 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
Associated Messages, from the most recent to the oldest:
>>> 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
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:
WebMerchant & CC Response (2002)
PIXO support (1997)
Authenticate (1997)
Variable is resetting itself... (2000)
Loss in Form (1998)
[sendmail] on NT? (1997)
Multiple Users.db Possible? (1997)
New Mac Public Beta Available (1997)
PSC recommends what date format yr 2000??? (1997)
Fwd: Emailer Error code 530? SMITHMICRO (2002)
Security Hole - NetCloak Update (1998)
How to download a database???/ (2000)
WebCat2.0 [format thousands .0f] no go (1997)
[WebDNA] Version 8 (2014)
Arbitrary limits on length of data in cart header fields? (2000)
Counting LineItems (2000)
mail on NT (1998)
Two prices in shoppingcart? (1997)
Re:quit command on NT (1997)
[OT] Xserve (2002)