Re: Mixing and/or in searches

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17069
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] Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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] Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

WebCatalog2 Feature Feedback (1996) Sorry WebDNA server not running ????? (2002) [WebDNA] 6.2 Monitor (2012) Searching (2000) expansion domain freak out (2003) Re:Searching for ALL / empty form field (1997) Input appreciated (2000) Credit card processing - UK (1997) [ShowNext] (1997) question: back button prevention (1997) Taxes rates based on item and State (1998) Falsifying [BROWSERNAME] (1998) WebCatalog can't find database (1997) Emailer Problem (2000) Date Calulation (1997) Dates (1996) WebCat2b12--[searchstring] bug (1997) View order not right (1997) Ampersand (1997) E-Mail (1998)