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:

Re: Quiz question: Return all green and blank records? (John Peacock 2001) Re: Quiz question: Return all green and blank records? (Clayton Randall 2001) Re: Quiz question: Return all green and blank records? (Clayton Randall 2001) Re: Quiz question: Return all green and blank records? (Bob McPeak 2001) Re: Quiz question: Return all green and blank records? (Clayton Randall 2001) Re: Quiz question: Return all green and blank records? (Anup Setty 2001) Re: Quiz question: Return all green and blank records? (Bob McPeak 2001) Re: Quiz question: Return all green and blank records? (Anup Setty 2001) Quiz question: Return all green and blank records? (Marc Kaiwi 2001)

[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:

docs for WebCatalog2 (1997) Shownext on AOL (2003) CAll me Crazy (2000) Displaying text and populating form fields (again) (2005) Server IP address (2004) WebCat hosting providers? (1997) Persistant Connections (2000) encryption madness (2003) Help! WebCat2 bug (1997) Target wit redirect (1998) is sku a REQUIRED field on NT (1997) Field name-subcategory (1997) [WebDNA] CORRECTION: 60% failure rate using replace in a loop (2010) Emailer (1998) WebCat2: Items xx to xx shown, etc. (1997) Attn: Bug in GeneralStore example b15 (1997) Comments in db? (1997) Error Lob.db records error message not name (1997) and vs or vs not (1998) forming a SKU (1999)