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 GromeWebDNA 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 GromeWebDNA 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:
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
taxrate - off by 1 cent (1997)
remotely creating and populating a stock inventory db -almostthere! (1999)
WebCat2b13MacPlugIn - more [date] problems (1997)
2 databases problem (1997)
[WebDNA] [OT] economical reliable SSL certs? (2009)
Summing fields (1997)
Logging purchases (1997)
OT Weird Messenger Service message (2002)
Download URL & access on the fly ? (1997)
WebDNA vs PHP (2003)
Hiding usernames and passwords in URL (1998)
Migrating to NT (1997)
Off Topic - OS X web server, FTP accounts (2003)
(1997)
taxTotal, grandTotal (1997)
RE: Loss in form (1998)
f2 download problems (1997)
Web Catalog vs. ICAT (1997)
[WebDNA] WebDNA Hosts (2009)