Re: case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29649
interpreted = N
texte = I have a clients FMP database that I am porting over to webcat and here is what I am trying to do. The client wants one part of the site to display a range of records based on the case number field.the format of the case number is:'XX A XXX' where X=Number and A=AlphaCharacterI want to search on a range like rnCaseNumberdata=00 F 701+00 F 714here is the code I have fighting with:[search db=../data/database.db&CaseNumberType=text &rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I tried a few different versions:[search db=../data/database c.db&CaseNumberType=text &CaseNumberword=+& rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]> From: Kenneth Grome
> Reply-To: (WebCatalog Talk) > Date: Mon, 27 Mar 2000 10:26:28 -1000 > To: (WebCatalog Talk) > Subject: Re: case number with spaces. > > 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 > ------------------------------------------------------------- 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 have a clients FMP database that I am porting over to webcat and here is what I am trying to do. The client wants one part of the site to display a range of records based on the case number field.the format of the case number is:'XX A XXX' where X=Number and A=AlphaCharacterI want to search on a range like rnCaseNumberdata=00 F 701+00 F 714here is the code I have fighting with:[search db=../data/database.db&CaseNumberType=text &rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I tried a few different versions:[search db=../data/database c.db&CaseNumberType=text &CaseNumberword=+& rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]> From: Kenneth Grome > Reply-To: (WebCatalog Talk) > Date: Mon, 27 Mar 2000 10:26:28 -1000 > To: (WebCatalog Talk) > Subject: Re: case number with spaces. > > 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 > ------------------------------------------------------------- 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:
table max? (2001)
flushing databases (2003)
[isfile] ? (1997)
Windows 2.1b2 Append Bug? (1997)
Odd search results, or odd programmer, not sure which... (2002)
re:check boxes (1997)
WebCatalog NT beta 18 now available (1997)
Need help with form (1998)
WebCatalog NT beta 18 problem (1997)
Limiting user access to .tmpl files (1997)
OT: Amazon Patents (2000)
Mauthonly followed by mauthcapture (2002)
WebDNA 6 (2004)
Another IfThenElse question.. (2003)
form data submission gets truncated (1997)
Cart date/time (2006)
form crasehes server (1997)
[WebDNA] [createdate] displays today's date on Ubuntu 14.04 / WebDNA Server 8.? (2014)
quotes and truncating? (1997)
WebCat2b15MacPlugin - showing [math] (1997)