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:
Make sure I understand this??? (1997)
ShowIf inside formulas (1997)
Showing unopened cart (1997)
Languages (1997)
Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998)
1st Comparison inside [fileinfo] broken. = bug? (2004)
Demo math questions (2000)
CommandSecurity? (1997)
Web Commerce thoughts and needs.. (1996)
Exact word search - continued (1998)
Show shoppingcart after remove last item (1997)
all records returned. (1997)
2nd WebCatalog2 Feature Request (1996)
RE: OK, here goes... (1997)
Need relative path explanation (1997)
SSL PROBLEM (1999)
WebTen and WebCat (1997)
Include a big block of text (1997)
Speeding up my [showif] performance (1999)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)