Re: Quiz question: Return all green and blank records?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37010
interpreted = N
texte = I tried exact same code and couldn't get it to work. It is the most obviousfirst try....Stumped....----- Original Message -----From: Clayton Randall
To: WebCatalog Talk Sent: Friday, July 06, 2001 1:08 PMSubject: Re: Quiz question: Return all green and blank records?> [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. Youruse> >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 examplebelow)> >> > 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/-------------------------------------------------------------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:
I tried exact same code and couldn't get it to work. It is the most obviousfirst try....Stumped....----- Original Message -----From: Clayton Randall To: WebCatalog Talk Sent: Friday, July 06, 2001 1:08 PMSubject: Re: Quiz question: Return all green and blank records?> [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. Youruse> >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 examplebelow)> >> > 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/-------------------------------------------------------------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/
Bob McPeak
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:
WebDNA vs PHP (2003)
% (mod) was looping table rows (1999)
beta 2 plugin (2000)
Error:Too many nested [xxx] contexts (1997)
categories (1997)
Freeze (2003)
Realtime shipping suggestions (2007)
[isfolder] and [filename] (1997)
[WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (2012)
Grant, please help me ... (1997)
Separate SSL Server (1997)
using showpage and showcart commands (1996)
problems with 2 tags (1997)
Sum of Quantities (1997)
[OT] DNS on Development Server (2004)
Missing contexts on NT (1997)
Thanks SMSI (2003)
WebMerchant Orders Won't Process (2002)
Errata: WCS Newbie question (1997)
Snake Bites (1997)