Re: Problem searching bw & ne of a word
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23988
interpreted = N
texte = >On 2/23/1999 2:32 pm, John Jakovich so noted... > >>The reason that it finds nothing is that you are doing two searches on the >>same field. Web Cat does not like that, but there is a trick that you can >>use to fool it into doing the search. > >Thanks John and Ken -- It's the simple ones that get you stuck : ) > >Is it absolutely not possible to do multiple searches on a single field >without grouping? When I had changed my search to >bwSkuDataRq=[p]&woSkuDataRq=0 (since I could be certain that each sku I >wanted would contain a zero) the search worked fine.I would never trust it, even though simetimes it *seems* to work ... so if your test results look correct, you still shouldn't try it unless you're prepared to deal with future problems.Upgrade Suggestion to PCS:It would be really nice if webcat could handle this internally, since there are lots of situations requiring multiple comparisons on a single field. It's much more direct to use multiple parameters on a real database field than to have to mess with grouped fields.Sincerely, Kenneth Grome WebDNA Consultant
Associated Messages, from the most recent to the oldest:
>On 2/23/1999 2:32 pm, John Jakovich so noted... > >>The reason that it finds nothing is that you are doing two searches on the >>same field. Web Cat does not like that, but there is a trick that you can >>use to fool it into doing the search. > >Thanks John and Ken -- It's the simple ones that get you stuck : ) > >Is it absolutely not possible to do multiple searches on a single field >without grouping? When I had changed my search to >bwSkuDataRq=[p]&woSkuDataRq=0 (since I could be certain that each sku I >wanted would contain a zero) the search worked fine.I would never trust it, even though simetimes it *seems* to work ... so if your test results look correct, you still shouldn't try it unless you're prepared to deal with future problems.Upgrade Suggestion to PCS:It would be really nice if webcat could handle this internally, since there are lots of situations requiring multiple comparisons on a single field. It's much more direct to use multiple parameters on a real database field than to have to mess with grouped fields.Sincerely, Kenneth Grome WebDNA Consultant
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:
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Setting up WebCatalog with Retail Pro data (1996)
High ASCII inside [LOOKUP] inside [LISTWORDS] (1998)
when is date system date or order date? (1997)
Whats the trick to tax. (2002)
Unable to open the demo file (1998)
process SSI (1998)
More Search Engine (2002)
Emailer (WebCat2) (1997)
[OT] Indexing of dynamic web sites (2003)
db creator (2000)
New site announcement + Showing once on a founditems (1997)
OT: Several requests (2003)
GoodPath and MoveFile (edited and reposted) (2000)
fixed date problem (1997)
oops private message leaked into talk list (1997)
Generating Report Totals (1997)
RE: Emailer prefs in two places ... (1997)
WebCatalog can't find database (1997)
database with 10,000+ web pages stored in it? (2000)