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:

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)