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:

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