Re: searching more then one

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23271
interpreted = N
texte = Change them to required fields by adding rq to the end of each search item like this:[search db=products.db&eqcategorydatarq=Powerbook&eqfeaturedatarq=T]This will return items that match both search criteria.JohnNitai wrote: > > Hi, > > I know this has to be simple, but can't get my brain working. > > I want to search my products.db for more then one field, but only want it to > display the one record with the value. > > My code goes like this: > > [search db=products.db&eqcategorydata=Powerbook&eqfeaturedata=T] > > With this I want to search for all records with the category Powerbook, > from all this records there is only one (or two) products with the feature > set to T (true). > > With the above code it gives me back all of the products with the category > Powerbook. > > Any suggestions? > > Sincerely, > Nitai > > *** > MacTrade - http://www.mactrade.ch > More Mac for your money > EMail: Info@mactrade.ch > Fax: 052 / 654 15 59 > *** Associated Messages, from the most recent to the oldest:

    
  1. Re: searching more then one (Martin Bech 1999)
  2. Re: searching more then one (John Winningham 1999)
  3. searching more then one (Nitai 1999)
Change them to required fields by adding rq to the end of each search item like this:[search db=products.db&eqcategorydatarq=Powerbook&eqfeaturedatarq=T]This will return items that match both search criteria.JohnNitai wrote: > > Hi, > > I know this has to be simple, but can't get my brain working. > > I want to search my products.db for more then one field, but only want it to > display the one record with the value. > > My code goes like this: > > [search db=products.db&eqcategorydata=Powerbook&eqfeaturedata=T] > > With this I want to search for all records with the category Powerbook, > from all this records there is only one (or two) products with the feature > set to T (true). > > With the above code it gives me back all of the products with the category > Powerbook. > > Any suggestions? > > Sincerely, > Nitai > > *** > MacTrade - http://www.mactrade.ch > More Mac for your money > EMail: Info@mactrade.ch > Fax: 052 / 654 15 59 > *** John Winningham

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:

Need help with Shipping/Price discounts (1998) [math] storage of variables (1997) removing programming logic white space (2003) I'm having trouble using [url][interpret][math] together in lookup (1997) One per customer (2000) [WebDNA] Two stores one db (2011) Re[2]: Next X hits (1996) [index] (1997) WebCatalog Serial Number (1998) [Replace] really replaces? (2000) More to Expire (1998) Some shell fun (2004) Slightly OT: [sendmail] help (2003) BGcolor (1997) Fun with Dates - revisited (1997) Re:Emailer and encryption (1997) normal users.db calls ... (1998) select multiple 2 more cents (1997) Search on encrypted field (2000) Roundup function? (1997)