Re: Quiz question: Return all green and blank records?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37008
interpreted = N
texte = You are probably right, I copied that code from something elseand modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!RegardsAnup Setty----- Original Message -----From: Bob McPeak
To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AMSubject: Re: Quiz question: Return all green and blank records?> 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 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/
Associated Messages, from the most recent to the oldest:
You are probably right, I copied that code from something elseand modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!RegardsAnup Setty----- Original Message -----From: Bob McPeak To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AMSubject: Re: Quiz question: Return all green and blank records?> 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 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/
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:
Striping Characters (1998)
WebCat2.0 [format thousands .0f] no go (1997)
Alternate Cookie location (2001)
cart file creation (2003)
[no_cache]?! (2000)
FAX orders (1996)
New Media Careers -- Jobs! (1998)
Emailer errors (1997)
Make sure I understand this??? (1997)
Storebuilder SOLVED!!!!!!! (2003)
Putting a page between checkout and invoice (1999)
Running _every_ page through WebCat ? (1997)
2nd try: possible to weight results of grouped fields search? (1998)
Help getting [shownext] to increment (2003)
Dealer locator (1998)
WebCat2b12--[searchstring] bug (1997)
WebCat2 - Getting to the browser's username/password data (1997)
MacActivity and PCS (1997)
Country & Ship-to address & other fields ? (1997)
SSL problems (1998)