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

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37010
interpreted = N
texte = 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/ 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)
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/ Bob McPeak

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 vs PHP (2003) % (mod) was looping table rows (1999) beta 2 plugin (2000) Error:Too many nested [xxx] contexts (1997) categories (1997) Freeze (2003) Realtime shipping suggestions (2007) [isfolder] and [filename] (1997) [WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (2012) Grant, please help me ... (1997) Separate SSL Server (1997) using showpage and showcart commands (1996) problems with 2 tags (1997) Sum of Quantities (1997) [OT] DNS on Development Server (2004) Missing contexts on NT (1997) Thanks SMSI (2003) WebMerchant Orders Won't Process (2002) Errata: WCS Newbie question (1997) Snake Bites (1997)