Re: Quiz question: Return all green and blank records?

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37011
interpreted = N
texte = You mean that Webcat does not behave the way the docs suggest they should work?>I tried exact same code and couldn't get it to work. It is the most obvious >first try.... > >Stumped.... > >----- Original Message ----- >From: Clayton Randall >To: WebCatalog Talk >Sent: Friday, July 06, 2001 1:08 PM >Subject: Re: Quiz question: Return all green and blank records? > > >> [search db=mydb.db&woSOMEFIELDdatarq=green,[blank]] >> >> >> product prizes are fine. >> >> >> >> >Don't think that's the answer. I'm working on a similar search. Your >use >> >of rq parameter would require that all returned records had both value >> >[blank] AND green in SOMEFIELD. >> > >> >He wants [blank] OR green. >> > >> >Correct me if I'm wrong. >> > >> >Here's where I'm at, after 20 mins of goofing off with this: >> > >> >[search >> >>db=my.db&eqSOMEFIELDdata=[blank]&group1field=SOMEFIELD&wogroup1fielddata=gr >e >> >en] >> > >> >But that doesn't work either. >> >----- Original Message ----- >> >From: Anup Setty >> >To: WebCatalog Talk >> >Sent: Friday, July 06, 2001 11:42 AM >> >Subject: Re: Quiz question: Return all green and blank records? >> > >> > >> >> [Search >> >> >> >>db=myd.db&eqSOMEFIELDdatarq=GREEN&group1field=SOMEFIELD&eqGroup1datarq=[bla >n >> >> k]] >> >> >> >> Try this, if this works for your, >> >> How can I get my Prize for solving this quiz? >> >> I would prefer cash to some merchandise :) >> >> >> >> Anup Setty >> >> >> >> ----- Original Message ----- >> >> From: Marc Kaiwi >> >> To: WebCatalog Talk >> >> Sent: Friday, July 06, 2001 11:17 AM >> >> Subject: Quiz question: Return all green and blank records? >> >> >> >> >> >> > SOLVE THIS QUIZ AND WIN A PRIZE! >> >> > >> >> > The problem is to return all the records with a SOMEFIELD value >> >> > containing green along with all of the records with with >> >> > SOMEFIELD = blank. The final correct result (for the example >below) >> >> > would be: >> >> > PN: 102 Data: >> >> > PN: 103 Data: red blue green >> >> > PN: 105 Data: >> >> > PN: 106 Data: blue green orange >> >> > >> >> > I've pulled out all of my hair over this one without success! : c) >> >> > >> >> > EXAMPLE BELOW: >> >> > >> >> > mydb.db: >> >> > --------------------------------------- >> >> > PN SOMEFIELD >> >> > 101 red blue orange >> >> > 102 >> >> > 103 red blue green >> >> > 104 orange black red >> >> > 105 >> >> > 106 blue green orange >> >> > --------------------------------------- > > >> > > > >> > [search db=mydb.db&gePNdata=0&YOUR ANSWER HERE] > > >> > [founditems] > > >> > PN: [PN] Data: [SOMEFIELD]
> > >> > [/founditems] > > >> > [/search] > > >> > > > >> > --------------------------------------- >> >> > >> >> > >> >> > -- >> >> > Marc Kaiwi, Internet Applications Development >> >> > RestoreClassics.com >> >> > 9606 Aero Drive Suite 1800 San Diego CA 92123 >> >> > Email: Marc@RestoreMustangs.com >> >> > Phone: (858) 836-0151 Ext. 385 >> >> > >> >> > >> >> > ------------------------------------------------------------- >> >> > This message is sent to you because you are subscribed to >> >> > the mailing list . >> >> > To unsubscribe, E-mail to: >> > > > To switch to the DIGEST mode, E-mail to >> > > >> > > > Web Archive of this list is at: http://search.smithmicro.com/ >> > > >> > > >> > > ------------------------------------------------------------- >> >> This message is sent to you because you are subscribed to >> >> the mailing list . >> >> To unsubscribe, E-mail to: >> >> To switch to the DIGEST mode, E-mail to >> > > > >> Web Archive of this list is at: http://search.smithmicro.com/ >> > >> > >> >------------------------------------------------------------- >> >This message is sent to you because you are subscribed to >> > the mailing list . >> >To unsubscribe, E-mail to: >> >To switch to the DIGEST mode, E-mail to >> > >> >Web Archive of this list is at: http://search.smithmicro.com/ >> >> >> -- >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://search.smithmicro.com/ > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Quiz question: Return all green and blank records? (John Peacock 2001)
  2. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  3. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  4. Re: Quiz question: Return all green and blank records? (Bob McPeak 2001)
  5. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  6. Re: Quiz question: Return all green and blank records? (Anup Setty 2001)
  7. Re: Quiz question: Return all green and blank records? (Bob McPeak 2001)
  8. Re: Quiz question: Return all green and blank records? (Anup Setty 2001)
  9. Quiz question: Return all green and blank records? (Marc Kaiwi 2001)
You mean that Webcat does not behave the way the docs suggest they should work?>I tried exact same code and couldn't get it to work. It is the most obvious >first try.... > >Stumped.... > >----- Original Message ----- >From: Clayton Randall >To: WebCatalog Talk >Sent: Friday, July 06, 2001 1:08 PM >Subject: Re: Quiz question: Return all green and blank records? > > >> [search db=mydb.db&woSOMEFIELDdatarq=green,[blank]] >> >> >> product prizes are fine. >> >> >> >> >Don't think that's the answer. I'm working on a similar search. Your >use >> >of rq parameter would require that all returned records had both value >> >[blank] AND green in SOMEFIELD. >> > >> >He wants [blank] OR green. >> > >> >Correct me if I'm wrong. >> > >> >Here's where I'm at, after 20 mins of goofing off with this: >> > >> >[search >> >>db=my.db&eqSOMEFIELDdata=[blank]&group1field=SOMEFIELD&wogroup1fielddata=gr >e >> >en] >> > >> >But that doesn't work either. >> >----- Original Message ----- >> >From: Anup Setty >> >To: WebCatalog Talk >> >Sent: Friday, July 06, 2001 11:42 AM >> >Subject: Re: Quiz question: Return all green and blank records? >> > >> > >> >> [Search >> >> >> >>db=myd.db&eqSOMEFIELDdatarq=GREEN&group1field=SOMEFIELD&eqGroup1datarq=[bla >n >> >> k]] >> >> >> >> Try this, if this works for your, >> >> How can I get my Prize for solving this quiz? >> >> I would prefer cash to some merchandise :) >> >> >> >> Anup Setty >> >> >> >> ----- Original Message ----- >> >> From: Marc Kaiwi >> >> To: WebCatalog Talk >> >> Sent: Friday, July 06, 2001 11:17 AM >> >> Subject: Quiz question: Return all green and blank records? >> >> >> >> >> >> > SOLVE THIS QUIZ AND WIN A PRIZE! >> >> > >> >> > The problem is to return all the records with a SOMEFIELD value >> >> > containing green along with all of the records with with >> >> > SOMEFIELD = blank. The final correct result (for the example >below) >> >> > would be: >> >> > PN: 102 Data: >> >> > PN: 103 Data: red blue green >> >> > PN: 105 Data: >> >> > PN: 106 Data: blue green orange >> >> > >> >> > I've pulled out all of my hair over this one without success! : c) >> >> > >> >> > EXAMPLE BELOW: >> >> > >> >> > mydb.db: >> >> > --------------------------------------- >> >> > PN SOMEFIELD >> >> > 101 red blue orange >> >> > 102 >> >> > 103 red blue green >> >> > 104 orange black red >> >> > 105 >> >> > 106 blue green orange >> >> > --------------------------------------- > > >> > > > >> > [search db=mydb.db&gePNdata=0&YOUR ANSWER HERE] > > >> > [founditems] > > >> > PN: [PN] Data: [SOMEFIELD]
> > >> > [/founditems] > > >> > [/search] > > >> > > > >> > --------------------------------------- >> >> > >> >> > >> >> > -- >> >> > Marc Kaiwi, Internet Applications Development >> >> > RestoreClassics.com >> >> > 9606 Aero Drive Suite 1800 San Diego CA 92123 >> >> > Email: Marc@RestoreMustangs.com >> >> > Phone: (858) 836-0151 Ext. 385 >> >> > >> >> > >> >> > ------------------------------------------------------------- >> >> > This message is sent to you because you are subscribed to >> >> > the mailing list . >> >> > To unsubscribe, E-mail to: >> > > > To switch to the DIGEST mode, E-mail to >> > > >> > > > Web Archive of this list is at: http://search.smithmicro.com/ >> > > >> > > >> > > ------------------------------------------------------------- >> >> This message is sent to you because you are subscribed to >> >> the mailing list . >> >> To unsubscribe, E-mail to: >> >> To switch to the DIGEST mode, E-mail to >> > > > >> Web Archive of this list is at: http://search.smithmicro.com/ >> > >> > >> >------------------------------------------------------------- >> >This message is sent to you because you are subscribed to >> > the mailing list . >> >To unsubscribe, E-mail to: >> >To switch to the DIGEST mode, E-mail to >> > >> >Web Archive of this list is at: http://search.smithmicro.com/ >> >> >> -- >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://search.smithmicro.com/ > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Clayton Randall

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:

Payment calculator ?? (2000) A little syntax help (1997) filtering extra characters from credit card numbers (2001) Cart/ Form Use (1998) Max Record length restated as maybe bug (1997) More Applescript (1997) [shownext] and descending order (1997) Search for starts with and ends with? (2003) [WebDNA] [OT] BBEdit Glossary (2012) Running _every_ page through WebCat-error.html (1997) Plugin or CGI or both (1997) Force leading zeros (1998) Nested tags count question (1997) autosensing lanague selection (1997) Emailer question (2003) [WebDNA] HTTP crashes (2010) setlineiems and UnitShip Cost (2000) For those of you not on the WebCatalog Beta... (1997) a new bug? (1999) [WebDNA] reverse rank=off (2008)