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

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37001
interpreted = N
texte = [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/ 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)
[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/ 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:

Configuring E-mail (1997) Big Databases (1997) [WebDNA] How can I uninstall WebDNA on OS X =?UTF-8?Q?Sierra=3F?= (2017) Waitfor(ever) (2002) Listserver problem (1997) Mac Scheduling (1998) Shopping carts and reloading pages (1997) stuck time (1998) More EudoraPro Email Options (1998) Error Log (2000) WCS Newbie question (1997) ANN: Strategic Partnership with BuyStream Announced. (2000) No luck with taxes (1997) MASTER_STORE revision (2002) tracking variables across a site... (2000) Server IP address (2004) color and size options (1997) Help name our technology! (1997) X etc.... (1999) Simple Store (2000)