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:

    
  1. Re: Problem searching bw & ne of a word (Kenneth Grome 1999)
  2. Re: Problem searching bw & ne of a word (Rob Marquardt 1999)
  3. Re: Problem searching bw & ne of a word (Kenneth Grome 1999)
  4. Re: Problem searching bw & ne of a word (John Jakovich 1999)
  5. Problem searching bw & ne of a word (Rob Marquardt 1999)
>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:

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)