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 = [Searchdb=myd.db&eqSOMEFIELDdatarq=GREEN&group1field=SOMEFIELD&eqGroup1datarq=[blank]]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 AMSubject: 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:
[Searchdb=myd.db&eqSOMEFIELDdatarq=GREEN&group1field=SOMEFIELD&eqGroup1datarq=[blank]]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 AMSubject: 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)