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 asfeatured or have been added to our stock in the last three weeks. Inaddition, I want all the found items to cost more than $10, and haveinventory greater than 5.I currently have:[SEARCHdb=My.db&grINVdatarq=5&grPRICEdatarq=10&pricetype=num&invtype=num&eqFEATdata=1&grCDATEdata=[MATH DATE]{[DATE]}-21[/MATH]&CDATEtype=date]I thought this would work, but instead I'm getting all featured items, allnew items, and all items that are greater than $10 and have more than 5 instock. When you think about it, this makes sense, but I don't know how toget the results that I want.What am I doing wrong?MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet 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:
I'm trying to perform a search that returns items that are marked asfeatured or have been added to our stock in the last three weeks. Inaddition, I want all the found items to cost more than $10, and haveinventory greater than 5.I currently have:[SEARCHdb=My.db&grINVdatarq=5&grPRICEdatarq=10&pricetype=num&invtype=num&eqFEATdata=1&grCDATEdata=[MATH DATE]{
[date]}-21[/MATH]&CDATEtype=date]I thought this would work, but instead I'm getting all featured items, allnew items, and all items that are greater than $10 and have more than 5 instock. When you think about it, this makes sense, but I don't know how toget the results that I want.What am I doing wrong?MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet 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)