Re: Searching for (field1 OR field2) AND field3
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26959
interpreted = N
texte = At 12:17 AM -0600 2000/02/03, Bob Minor wrote:>On 2/3/00 12:00 AM, Chuck Rice wrote:>>>So if checkbox 1 and 3 are checked, then I want to say:>>>> if ((tree1 NE [blank] OR tree3 NE blank) AND (First EQ Trevor)) then>>show the record.>>>>likewise, if only checkbox 2 is checked, then I want to say:>>>> if ((tree1 NE [blank]) AND (Last EQ Trevor)) then show the record.>>The problem with your theory is that sometimes tree1 doesn't exist as is>the case with the other 3. What are the actual fields in the database?>Why the cryptic underscore before each entry?The fields are (from the header)SKU RTREE CTREE HTREE FIRST MIDDLE LAST KIDS STREET1 STREET2 CITY STATE ZIP FPHONE COMPANY OTHER HPHONE WPHONE CLASSIFICATION MOVE FIRSTLAST PPHONE CPHONE BIRTHDAY WEBSITE EMAIL LUPDATE PTREE The underscores are from the code generated by the DataBase Helper which I used as a starting point. (I am kind of new to WebCat). The search in results.tpl is [search db=ABook.db&[formvariables name=_&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables]startat=[ startat]]I chose this method because of DBHelper. I assumed that it would point me in the right direction.> >