Re: case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29651
interpreted = N
texte = >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 wanted to return case numbers '00 F 700' to '00 G 714'.You have to use the wbrk parameter if you don't want the default word break characters -- such as space -- to be used in your search. The proper technique is explained in the HTML docs on the SearchWordBreaks.html page, here it is:You can define your own custom list of word break characters with
wbrk=. So adding Descriptionwbrk=.,- to your search will cause user-entered text in the HTML form field Description that is surrounded by those characters to be considered as individual words.In other words, aall you need to do is use the wbrk parameter to define the word break character as something *other than* the default space -- since your data has spaces in it -- and then it will work just fine. Try defining a comma as your wbrk character for example:[search db=xxx.db&rnfieldnamedatarq=00 F 700,00 G 714&fieldnamewbrk=,]================================ 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:
>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 wanted to return case numbers '00 F 700' to '00 G 714'.You have to use the wbrk parameter if you don't want the default word break characters -- such as space -- to be used in your search. The proper technique is explained in the HTML docs on the SearchWordBreaks.html page, here it is:You can define your own custom list of word break characters with wbrk=. So adding Descriptionwbrk=.,- to your search will cause user-entered text in the HTML form field Description that is surrounded by those characters to be considered as individual words.In other words, aall you need to do is use the wbrk parameter to define the word break character as something *other than* the default space -- since your data has spaces in it -- and then it will work just fine. Try defining a comma as your wbrk character for example:[search db=xxx.db&rnfieldnamedatarq=00 F 700,00 G 714&fieldnamewbrk=,]================================ 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:
XML Syntax, Cookies and Variables.... (2004)
Running 2 two WebCatalog.acgi's (1996)
multi-paragraph fields (1997)
Calendar Snippet Available (1998)
Tax on Shipping question (1998)
shipCost not working v2.1b4 (1997)
Search design (1997)
SUBMIT buttons not working.... (2000)
[WebDNA] Mondy morn... [date] question (2009)
Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
E-Mail Preferences in Admin Folder (1997)
[SearchString] usage (1997)
Trapping Emailer Errors (2002)
verify online (1997)
[WebDNA] [table] weirdness maybe? (2014)
RE: Nesting [ListFiles] (1998)
[date format] w/in sendmail (1997)
BadSuffix with 2.1b3 cgi (1997)
Database changes (1998)
SAVECART (1997)