Re: MetaKW tags from databases

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67149
interpreted = N
texte = WJ Starck wrote: > I would parse the results into a table or a temp.db first, then search > that and append a fieldnamesumm=T onto the end of the search for those > fields you want to summarize which will factor out all your duplicates. > > If I'm understanding the question, I believe this is what you are after. Thanks, but I'm afraid that solution won't work in this case. One problem is the sheer volume. We're talking tens of thousands of page hits per day, each requiring a new table/temp file. That can be fixed if I can find a hundred percent reliable way to separate search spider visits from "real" hits but I'm not sure that's possible. Although most spiders are easily identifiable, I have this feeling some of them are cloaked as regular visitors. Another problem is that the fields that need to be summerised aren't single word fields. Something like this is not unlikely: Field1: value1 value2 value3 value1 value4 value1 Field2: value4 value3 value5 value6 Field3: value7 value1 value1 value2 So how do I get WebDNA to turn that into: value1 value2 value3 value4 value5 value6 value7 Frank Nordberg http://www.musicaviva.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: MetaKW tags from databases ( Brian Fries 2006)
  2. Re: MetaKW tags from databases ( Frank Nordberg 2006)
  3. Re: MetaKW tags from databases ( "WJ Starck" 2006)
  4. MetaKW tags from databases ( Frank Nordberg 2006)
WJ Starck wrote: > I would parse the results into a table or a temp.db first, then search > that and append a fieldnamesumm=T onto the end of the search for those > fields you want to summarize which will factor out all your duplicates. > > If I'm understanding the question, I believe this is what you are after. Thanks, but I'm afraid that solution won't work in this case. One problem is the sheer volume. We're talking tens of thousands of page hits per day, each requiring a new table/temp file. That can be fixed if I can find a hundred percent reliable way to separate search spider visits from "real" hits but I'm not sure that's possible. Although most spiders are easily identifiable, I have this feeling some of them are cloaked as regular visitors. Another problem is that the fields that need to be summerised aren't single word fields. Something like this is not unlikely: Field1: value1 value2 value3 value1 value4 value1 Field2: value4 value3 value5 value6 Field3: value7 value1 value1 value2 So how do I get WebDNA to turn that into: value1 value2 value3 value4 value5 value6 value7 Frank Nordberg http://www.musicaviva.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Frank Nordberg

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:

Fwd: [WebDNA] Add to Cart,/ show cart: unable to access page (2016) View Source from cache (1997) OH MY GOD! (1998) Search Questions (2000) WCf2 and nested tags (1997) Searching multiple Databases (1997) weird happenings (1997) [format] (1998) webcat2b12 CGI -- Date comparisons (1997) Email Spam a bit of Hell (2004) Grouping search fields, etc. (1997) Execute Applescript (1997) WebCat2b15MacPlugin - [protect] (1997) wee problem (2001) 2nd WebCatalog2 Feature Request (1996) WebCatalog NT (1996) RequiredFields template (1997) Rhapsody? (1997) PSC recommends what date format yr 2000??? (1997) Type 11 errors setting up WebCAt 2 (1997)