Re: Reporting form..

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39840
interpreted = N
texte = Chas -You cannot directly perform multiple comparisons within one field in a search. There are a couple ways around this, depending on your situation.If t1, t2, etc, as well as the theme field, are singular words, you could use a word or search like this...[search db=[tRoot]db/theme.db&wothemedata=[t1]+[t2]+[t3]+[t4]+[t5]+[t6]+[t7]&themesumm=T&allreqd=T]If you've got spaces in your values this won't work though, cause if, for example, t2 contained the blues then all theme values containing the would match.Another way that would handle this situation would be to create multiple field groups which each contain only the theme field, and to search each of those field groups once. Note that you don't want allreqd=T in this case, asFrom ???@??? Mon Nov 05 07:24:43 2001 Return-Path: X-ListServer: CommuniGate Pro LIST 3.4.2 List-Unsubscribe: Message-ID: Reply-To: (WebCatalog Talk) Sender: (WebCatalog Talk) To: (WebCatalog Talk) Precedence: list X-Original-Message-ID: <00b901c16319$34c459a0$0b01010a@thewwwstore> From: Arturo Vargas Subject: emailer error 452 Date: Thu, 1 Nov 2001 13:07:25 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1Does anybody know what error 452 is on the emailer?or perhaps where to find a list of errors for future refferenceArt ------------------------------------------------------------- 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:

    
  1. Re: Reporting form.. (Brian Fries 2001)
  2. Re: Reporting form.. (Brian Fries 2001)
  3. Reporting form.. (chas@valley.net (chas) 2001)
Chas -You cannot directly perform multiple comparisons within one field in a search. There are a couple ways around this, depending on your situation.If t1, t2, etc, as well as the theme field, are singular words, you could use a word or search like this...[search db=[tRoot]db/theme.db&wothemedata=[t1]+[t2]+[t3]+[t4]+[t5]+[t6]+[t7]&themesumm=T&allreqd=T]If you've got spaces in your values this won't work though, cause if, for example, t2 contained the blues then all theme values containing the would match.Another way that would handle this situation would be to create multiple field groups which each contain only the theme field, and to search each of those field groups once. Note that you don't want allreqd=T in this case, asFrom ???@??? Mon Nov 05 07:24:43 2001 Return-Path: X-ListServer: CommuniGate Pro LIST 3.4.2 List-Unsubscribe: Message-ID: Reply-To: (WebCatalog Talk) Sender: (WebCatalog Talk) To: (WebCatalog Talk) Precedence: list X-Original-Message-ID: <00b901c16319$34c459a0$0b01010a@thewwwstore> From: Arturo Vargas Subject: emailer error 452 Date: Thu, 1 Nov 2001 13:07:25 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1Does anybody know what error 452 is on the emailer?or perhaps where to find a list of errors for future refferenceArt ------------------------------------------------------------- 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/ Brian Fries

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:

Summing fields (1997) delete credit card number (2002) File Upload (1997) [quantity] solved (1997) Email encryption (1998) WebCat2b15MacPlugin - showing [math] (1997) Foreign Chars (יאצה and so on) (1998) Re:Running 2 two WebCatalog.acgi's (1996) Summing fields (1997) GIF Converter vs. Clip2Gif (2000) Sku numbers (1997) WebCat2 beta 11 - new prefs ... (1997) Formulas.db + Users.db (1997) OT: zipcodes (2002) FYI: SmithMicro Financial Report (2000) any suggestions for creating a multi-lingual site? (1999) Question about replacing words (1998) WAP and IIS server (2002) [WebDNA] OT - does anyone know how to get Fetch/BBedit to leave (2009) Using Web* mail instead of Emailer? (1999)