Mixing and/or in searches

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17061
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]I thought this would work, but instead I'm getting all featured items, all new items, and all items that are greater than $10 and have more than 5 in stock. When you think about it, this makes sense, but I don't know how to get the results that I want.What am I doing wrong?MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440 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]I thought this would work, but instead I'm getting all featured items, all new items, and all items that are greater than $10 and have more than 5 in stock. When you think about it, this makes sense, but I don't know how to get the results that I want.What am I doing wrong?MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440 Michael Winston

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:

[WebDNA] Pages dying (2008) SSL and reg web*L and reg web* (1997) Additional Problems. (2000) Using the sendmail command on CGate Pro (Unix) (2000) What am I missing (1997) WebCatalog and WebMerchant reviewed by InfoWorld (1997) [OT] (waaaay OT) (2004) Pieces Show Up! Curse You! (2000) CommandSecurity? (1997) Dumb Question about Docs (1997) WebCatalog for guestbook ? (1997) Banner Ad example (Typhoon) and WebCatalog (1997) [ot] Dreamweaver & Mac OSX (2002) [WebDNA] 64-bit CentOS 6.3 (2013) b12 cannot limit records returned and more. (1997) WebCat2 - many [carts] on one template page? (1997) founditems (2000) Archives are missing (2003) [WebDNA] max=0 returns all records (2010) recomend ftp (2001)