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 else and modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!Regards Anup Setty----- Original Message ----- From: Bob McPeak To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AM Subject: 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 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:

    
  1. Re: Quiz question: Return all green and blank records? (John Peacock 2001)
  2. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  3. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  4. Re: Quiz question: Return all green and blank records? (Bob McPeak 2001)
  5. Re: Quiz question: Return all green and blank records? (Clayton Randall 2001)
  6. Re: Quiz question: Return all green and blank records? (Anup Setty 2001)
  7. Re: Quiz question: Return all green and blank records? (Bob McPeak 2001)
  8. Re: Quiz question: Return all green and blank records? (Anup Setty 2001)
  9. Quiz question: Return all green and blank records? (Marc Kaiwi 2001)
You are probably right, I copied that code from something else and modified it, looks like I forgot to get rid of rq.May be I can get a consolation prize!Regards Anup Setty----- Original Message ----- From: Bob McPeak To: WebCatalog Talk Sent: Friday, July 06, 2001 11:56 AM Subject: 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 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/ 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:

List Address Changed! (1998) Review comparison by PC Magazine: Open for On-line Business (1997) Server Freeze (1998) select multiple 2 more cents (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WebCat2b13MacPlugIn - more [date] problems (1997) Re:Emailer and encryption (1997) Safari browser and WebDNA set-cookies (2003) Suddenly can't see files... (2000) rename a file (1997) Re:[ShowIf] and empty fields (1997) [SearchString] problem with [search] context (1997) WebCatalog for guestbook ? (1997) Emailer (1997) Getting Emailer to send mail (1997) Uh...can someone help me out with the b10? (1997) What am I doing wrong? (2000) What if SSL server down? MAC (1997) WebCAT MacOS9 --> OSX (2003) Which GUI HTML editors work with WC ? (1997)