What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

MacAuthorize and WebMerchant (1997) Sorting by date (1997) WebCatalog not running after upgrade (2000) [WebDNA] APCN SPECIALS: Test eMail (2014) The List is Changing (1997) Date/Time format problems (1997) OOPS [Was: OH CRAP!!!!!- Template not found error!!! ] (1999) Error:Too many nested [xxx] contexts (1997) [ot] iBook vs. 12" PB (2004) [SearchString] problem with [search] context (1997) redirect from the errorsMessages.db entry (1997) Rhapsody? (1997) What am I doing wrong? (2000) Sort (2003) webmerchant/ Mac Auth. and CC refunds (1998) Catalog page question (1999) WebCatalog 3 manual (1998) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Unexpected error (1997) WebDNA Book? (2003)