Re: Quiz question: Return all green and blank records?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37002
interpreted = N
texte = Don't think that's the answer. I'm working on a similar search. Your useof 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:[searchdb=my.db&eqSOMEFIELDdata=[blank]&group1field=SOMEFIELD&wogroup1fielddata=green]But that doesn't work either.----- Original Message -----From: Anup Setty
To: WebCatalog Talk Sent: Friday, July 06, 2001 11:42 AMSubject: 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/
Associated Messages, from the most recent to the oldest:
Don't think that's the answer. I'm working on a similar search. Your useof 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:[searchdb=my.db&eqSOMEFIELDdata=[blank]&group1field=SOMEFIELD&wogroup1fielddata=green]But that doesn't work either.----- Original Message -----From: Anup Setty To: WebCatalog Talk Sent: Friday, July 06, 2001 11:42 AMSubject: 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/
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:
WebCat hosting providers? (1997)
sort on categories (DBEdit) (2001)
Help Wanted/Stowe, Vermont (2001)
re: Large databases in WebCat (1997)
popmenus database and line items (2000)
suffix mapping for NT? (1997)
RE: Multithreading of [replace] (1999)
Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= (2004)
Forms Search Questions (1997)
total number of matches (1999)
[WebDNA] No more SQL in 7.1? (2012)
Image maps/Webcat (1997)
Quest renew freware program for FunnelWeb! (2006)
unable to launch acgi in WebCat (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Looking up two prices in Formulas.db (1997)
Beta version-Mac? (was Emailer update for Mac?) (1998)
Location of Browser Info.txt file (1997)
[OT] CSS div/span (2004)
Ship Cost Not working (2000)