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 searchitem 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:
Change them to required fields by adding rq to the end of each searchitem 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)