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 CODE 1 2001 2002 2003 2 2002 2003 3 2003 4 2001 2003 5 2001 2002 6 2004 2003and the following code:[SEARCH db=/db/test.db&wnCODEdatarq=2002&CODEword=ww&group1field=code&wnGROUP1datarq=200 1&GROUP1word=ww] [FOUNDITEMS] [SKU]
[/FOUNDITEMS] [/SEARCH]I get the following results:3 6 MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet 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:

    
  1. Re: Is this possible in simple search? question? (Michael Winston 1998)
  2. Re: Is this possible in simple search? question? (Kenneth Grome 1998)
  3. Re: Is this possible in simple search? question? (Kenneth Grome 1998)
  4. Re: Is this possible in simple search? question? (Michael Winston 1998)
  5. Is this possible in simple search? question? (Gary Richter 1998)
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 CODE 1 2001 2002 2003 2 2002 2003 3 2003 4 2001 2003 5 2001 2002 6 2004 2003and the following code:[SEARCH db=/db/test.db&wnCODEdatarq=2002&CODEword=ww&group1field=code&wnGROUP1datarq=200 1&GROUP1word=ww] [founditems] [SKU]
[/FOUNDITEMS] [/SEARCH]I get the following results:3 6 MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet 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)