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:
[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:
Custom Shipping Charges (1997)
America Online Issues (1998)
Roundup function? (1997)
Cookies? (1997)
Email Attachments (1998)
WebCat2b13MacPlugIn - [include] (1997)
Include a big block of text (1997)
Sort Order on a page search (1997)
Practice runs ? (1997)
EIMS Problems (1997)
Extended [ConvertChars] (1997)
Talk list... (2000)
WebCat2b13MacPlugIn - syntax to convert date (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
WCf2 and nested tags (1997)
RE: Custom error files (1998)
[date] problem with %d%m%Y (1998)
Partner Edition question ... (2003)
Re:2nd WebCatalog2 Feature Request (1996)
CC Merchant suggestions?? (1997)