Re: Quiz question: Return all green and blank records?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37012
interpreted = N
texte = Here is the one I got to give me the 4 we are looking for [search db=mydb.db&eqSOMEFIELDdatarq=[blank]][text]finders=[/text] [founditems][text]finders=[finders],[PN][/text][/founditems] [/search][search db=mydb.db&woSOMEFIELDdatarq=green] [founditems][text]finders=[finders],[PN][/text][/founditems] [/search][search db=mydb.db&woPNdata=[finders]] [founditems][PN]-----[somefield]
[/founditems] [/search] >You mean that Webcat does not behave the way the docs suggest they >should work? > >>I tried exact same code and couldn't get it to work. It is the most obvious >>first try.... >> >>Stumped.... >> >>----- Original Message ----- >>From: Clayton Randall
>>To: WebCatalog Talk >>Sent: Friday, July 06, 2001 1:08 PM >>Subject: 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. 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=gr >>e >>> >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=[bla >>n >>> >> 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/ >> >> >>------------------------------------------------------------- >>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:
Here is the one I got to give me the 4 we are looking for [search db=mydb.db&eqSOMEFIELDdatarq=[blank]][text]finders=[/text] [founditems][text]finders=[finders],[PN][/text][/founditems] [/search][search db=mydb.db&woSOMEFIELDdatarq=green] [founditems][text]finders=[finders],[PN][/text][/founditems] [/search][search db=mydb.db&woPNdata=[finders]] [founditems][PN]-----[somefield]
[/founditems] [/search] >You mean that Webcat does not behave the way the docs suggest they >should work? > >>I tried exact same code and couldn't get it to work. It is the most obvious >>first try.... >> >>Stumped.... >> >>----- Original Message ----- >>From: Clayton Randall >>To: WebCatalog Talk >>Sent: Friday, July 06, 2001 1:08 PM >>Subject: 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. 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=gr >>e >>> >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=[bla >>n >>> >> 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/ >> >> >>------------------------------------------------------------- >>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:
formatting search results (1999)
[OT] ssh user@domain.com (2004)
Merry Christmas (2006)
Banners (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Was it something I said??? (1998)
Various Problems (1997)
what run level should S90WebCatalog be at? (2003)
WebCat2 several catalogs? (1997)
Stay on Products page (2003)
Shipping based in distance and weight (1999)
Support suggestions - long (was politeness, et al) (2000)
bug in [SendMail] (1997)
[TaxableTotal] - not working with AOL and IE (1997)
re: Large databases in WebCat (1997)
Linux Beta4 Problem (2000)
Full text search (1999)
Showif -what am I missing??? (1999)
[Sum] function? (1997)
PCS Frames-Default page is solution! (1997)