Re: Is this possible in simple search? question?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17256
interpreted = N
texte = At 1:14 PM -0800 4/24/98, Kenneth Grome is rumored to have typed:> >If I understand correctly, this should work:> >[SEARCH>>>db=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=1>0> >03&GROUP1word=ww]>> This is a good start, but it will not work, because whenever you use>grouped fields, you must use a different group for EACH search parameter>that's related to the original db field. You cannot use the original field>name in one parameter and the group field name in another parameter.No, the code works fine.Using the following db:SKU CODE1 2001 2002 20032 2002 20033 20034 2001 20035 2001 20026 2004 2003and the following code:[SEARCHdb=/db/test.db&wnCODEdatarq=2002&CODEword=ww&group1field=code&wnGROUP1datarq=2001&GROUP1word=ww][FOUNDITEMS][SKU]
[/FOUNDITEMS][/SEARCH]I get the following results:36MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet Coordinator *By web!: http://www.dhorse.com/Dark Horse Comics, Inc. *By fax!: 503/654/9440
Associated Messages, from the most recent to the oldest:
At 1:14 PM -0800 4/24/98, Kenneth Grome is rumored to have typed:> >If I understand correctly, this should work:> >[SEARCH>>>db=/DATABASE.db&waCODEdatarq=1002&CODEword=ww&group1field=CODE&wnGROUP1datarq=1>0> >03&GROUP1word=ww]>> This is a good start, but it will not work, because whenever you use>grouped fields, you must use a different group for EACH search parameter>that's related to the original db field. You cannot use the original field>name in one parameter and the group field name in another parameter.No, the code works fine.Using the following db:SKU CODE1 2001 2002 20032 2002 20033 20034 2001 20035 2001 20026 2004 2003and the following code:[SEARCHdb=/db/test.db&wnCODEdatarq=2002&CODEword=ww&group1field=code&wnGROUP1datarq=2001&GROUP1word=ww]
[founditems][SKU]
[/FOUNDITEMS][/SEARCH]I get the following results:36MichaelMichael Winston *By e-mail!: michaelw@dhorse.comInternet Coordinator *By web!: http://www.dhorse.com/Dark Horse Comics, Inc. *By fax!: 503/654/9440
Michael Winston
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:
WebCatb15 Mac CGI -- [purchase] (1997)
Adding Message to Order (1997)
Emailer prefs in two places ... (1997)
Database cloning, or possible hack? (2003)
[sendmail] on NT? (1997)
PDF Writefile problem (2005)
japanese characters (1997)
quitting (1997)
vCards for Contact management (2004)
Out of the woodwork (2007)
Country & Ship-to address & other fields ? (1997)
Multiple catalog databases and showcart (1997)
referrer and no caches (1997)
Emailer help....! (1997)
[WebDNA] Secure cookies (HttpOnly/Secure) (2013)
Okay, I give up... (1999)
Permission Denied Error (2001)
checksum for Discover credit cards (1999)
[WriteFile] problems (1997)
For you Unix gurus [OT] (2002)