Re: Quiz question: Return all green and blank records?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37009
interpreted = N
texte = [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=gre>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=[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/>>>------------------------------------------------------------->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=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=gre>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=[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/>>>------------------------------------------------------------->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/
Clayton Randall
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:
Frames and WebCat (1997)
Duplicate Cart #'s (1998)
[template] tag (1998)
Country & Ship-to address & other fields ? (1997)
Subtotal Not Calculated on Invoice.html (1998)
WebCat2 beta 11 - new prefs ... (1997)
Multi-processor Mac info ... (1997)
{Grouping} Docs (1999)
listfiles, moving files (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
can webcat determine an image's pixel dimensions? (2000)
Gettting IPAddress (2001)
Re1000001: Setting up shop (1997)
Need some Java Script Code (2003)
[/application] error? (1997)
Error with [applescript] (1999)
Founditems context returning only 1 item (1997)
WebCat website for developers and hosters (2001)
Loops N Variables (1998)
Re:listfiles-looking for slick solution (1997)