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

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37008
interpreted = N
texte = You are probably right, I copied that code from something else and modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!Regards Anup Setty----- Original Message ----- From: Bob McPeak To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AM Subject: Re: Quiz question: Return all green and blank records? > 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=gre > 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=[blan > > 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/ 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 are probably right, I copied that code from something else and modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!Regards Anup Setty----- Original Message ----- From: Bob McPeak To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AM Subject: Re: Quiz question: Return all green and blank records? > 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=gre > 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=[blan > > 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/ Anup Setty

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] New problem with [ShowNext] (2010) What am I missing (1997) Error Lob.db records error message not name (1997) PCS Emailer's role ? (1997) New One (for me).... Error type 12 (1999) Too many tabs in order file? (1998) Pixel parameters (2000) Calendar (1997) two unique banners on one page (1997) Shipping Costs (1999) WebCat & cookies (1998) [WebDNA] JSONStore Levels (2020) [WriteFile] problems (1997) Summing fields (1997) Stumped on ShowNext -using variables (1997) Sort Order on a page search (1997) Sorting Numbers (1997) WebCatalog for guestbook ? (1997) download a file (2001) Max Record length restated as maybe bug (1997)