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:
How to Display text in empty fields (1997)
Custom Shipping Charges (1997)
Payment calculator ?? (2000)
displaying New products (using [date]) (1997)
Cart # Starting at 1000 (2000)
ListFields and [name] (1997)
WebCatalog can't find database (1997)
can webcat determine an image's pixel dimensions? (2000)
unable to launch acgi in WebCat (1997)
Dismissing dialogs (was 2.1b3 --> way slow) (1997)
Nested tags count question (1997)
One other big addition... (1997)
Help formatting search results w/ table (1997)
Header Problems (1998)
WebCatalog2 Feature Feedback (1996)
Webcatalog, Webstar and Crasharama (1999)
Resume Catalog ? (1997)
New Command prefs ... (1997)
WebDNA Writer Needed (1997)
Fwd: Job Opening (2003)