Re: Mixing and/or in searches

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17072
interpreted = N
texte = >>I'm trying to perform a search that returns items that are marked as >>featured or have been added to our stock in the last three weeks. In >>addition, I want all the found items to cost more than $10, and have >>inventory greater than 5. >> >>I currently have: >>[SEARCH >>db=My.db&grINVdatarq=5&grPRICEdatarq=10&pricetype=num&invtype=num&eqFEATdata=1 >>&g >>rCDATEdata=[MATH DATE]{[DATE]}-21[/MATH]&CDATEtype=date] > > >Try this: > >[SEARCH db=My.db&eqFEATdata=1&CDATEtype=date&grCDATEdata=[MATH >DATE]{[DATE]}-21[/MATH]] > [founditems] > [showif [price]>10] > [showif [inv]>5] > --this is where the proper founditems will be displayed-- > [/showif] > [/showif] > [/founditems] >[/search]I don't think this is necessary. I think Michael's original search would be right if he just adds &AllReqd=T at the end (and skips the rq in the rest of the context if he wants a cleaner code). ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Associated Messages, from the most recent to the oldest:

    
  1. Re: Mixing and/or in searches (Michael Winston 1998)
  2. Re: Mixing and/or in searches (Christer Olsson 1998)
  3. Re: Mixing and/or in searches (Kenneth Grome 1998)
  4. Mixing and/or in searches (Michael Winston 1998)
>>I'm trying to perform a search that returns items that are marked as >>featured or have been added to our stock in the last three weeks. In >>addition, I want all the found items to cost more than $10, and have >>inventory greater than 5. >> >>I currently have: >>[SEARCH >>db=My.db&grINVdatarq=5&grPRICEdatarq=10&pricetype=num&invtype=num&eqFEATdata=1 >>&g >>rCDATEdata=[MATH DATE]{[date]}-21[/MATH]&CDATEtype=date] > > >Try this: > >[SEARCH db=My.db&eqFEATdata=1&CDATEtype=date&grCDATEdata=[MATH >DATE]{[date]}-21[/MATH]] > [founditems] > [showif [price]>10] > [showif [inv]>5] > --this is where the proper founditems will be displayed-- > [/showif] > [/showif] > [/founditems] >[/search]I don't think this is necessary. I think Michael's original search would be right if he just adds &AllReqd=T at the end (and skips the rq in the rest of the context if he wants a cleaner code). ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Christer Olsson

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:

Sorting by date (1997) problems with 2 tags (1997) Re[2]: when is failing to [URL]ize values in a comparison ri (1999) Help! WebCat2 bug (1997) Thanks ! (1997) Me know logical no need (2002) WebCat with WebTen (1998) [quantity] within formulas (1997) Extended [ConvertChars] (1997) [WAY OFF TOPIC] anybody live in Kansas? (2003) Date Sorting (1997) Emailer help....! (1997) Emailer error 550? (1999) NT version and O'reily's WebSite (1997) [no_cache]?! (2000) Running 2 two WebCatalog.acgi's (1996) Silly Question (2003) Another question (1997) webcat- multiple selection in input field (1997) WebDNA implementation of MD5 algorithm? (2003)