RE: [WebDNA] Basic Search

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100088
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_04C2_01C8DB61.258939C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Should I change the text variable to a math variable as just suggested? And do I need the show=f in it? Mike _____ From: Michael A. DeLorenzo [mailto:michael@oldecarriage.com] Sent: Tuesday, July 01, 2008 9:54 AM To: talk@webdna.us Subject: RE: [WebDNA] Basic Search OK almost there but something is duplicating things. Here is the code so far. Not that I am trying to do this in an embedded search. The first search goes into my database which holds my pages, each of which has a unique sku and fides all of the pages. The next search takes the sku of each page and searches the log file and tries to summarize the number of hits to that page (identified by sku) but the final count for each page can not include the hits from any ip address beginning with 192, thus the hideif. [text]hitcount=0[/text] [search db=../dbs/oldecarriage.db&neskudatarq=0] [founditems] [sku] has had [search db=listingsLog.db&eqskudatarq=[sku]] [founditems] [hideif [ipaddress]~192][text]hitcount=[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Here are the results http://72.242.199.250/oldecarriage/logs/listingsLogSummary.tpl Michael A. DeLorenzo Web: www.oldecarriage.com _____ From: Charles Kline [mailto:ckline@rightcode.net] Sent: Tuesday, July 01, 2008 9:37 AM To: Subject: Re: [WebDNA] Basic Search use a counter. if you give a little more detail I can give better advice, but you could do like... [math]counter=0[/math] [search] [founditems] [math]counter=counter+1/math[] [/founditems] [/search -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 9:29 AM, "Michael A. DeLorenzo" wrote: But then the numfound number will be incorrect. Any other ideas? Michael A. DeLorenzo www.oldecarriage.com _____ From: Charles Kline [mailto:ckline@rightcode.net] Sent: Tuesday, July 01, 2008 9:21 AM To: Subject: Re: [WebDNA] Basic Search I'd just filter the results. Just use a hideif. -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 8:53 AM, "Michael A. DeLorenzo" < michael@oldecarriage.com> wrote: Hi all, I have not used WebDNA for a while (but damn glad to be back) and have stumbled into a roadblock. I have a custom log file and I am trying to summarize the number of hits to a single page but wish to exclude all the recorded hits from any ip address beginning with 192. I know I can do it with math but isn't there an easier way. Something along the lines of: [search db=Log.db&eqskudatarq=[sku]&neipaddressbw=192] [numfound] [/search] Thanks for any help you may have to offer. Mike ------=_NextPart_000_04C2_01C8DB61.258939C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Should I change the text variable = to a math variable as just suggested? And do I need the show=3Df in = it?

 

Mike

 


From: = Michael A. DeLorenzo [mailto:michael@oldecarriage.com]
Sent: Tuesday, July 01, = 2008 9:54 AM
To: talk@webdna.us
Subject: RE: [WebDNA] = Basic Search

 

OK almost there but something is duplicating things. Here is the code so = far.

 

Not that I am trying to do this in = an embedded search. The first search goes into my database which holds my = pages, each of which has a unique sku and fides all of the pages. The next = search takes the sku of each page and searches the log file and tries to = summarize the number of hits to that page (identified by sku) but the final count for = each page can not include the hits from any ip address beginning with 192, = thus the hideif.

 

[text]hitcount=3D0[/text]=

[search db=3D../dbs/oldecarriage.db&neskudatarq=3D0]=

      =       [founditems]

      =       [sku] has had

      =             &= nbsp;     [search = db=3DlistingsLog.db&eqskudatarq=3D[sku]]

=

      =             &= nbsp;           &n= bsp;     [founditems]

      =             &= nbsp;           &n= bsp;           &nb= sp;     [hideif = [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif= ]

      =             &= nbsp;           &n= bsp;     [/founditems]

      =             &= nbsp;     [/search]

      =       [hitcount] page views.<br>

      =       [/founditems]

[/search]

 

Here are the results h= ttp://72.242.199.250/oldecarriage/logs/listingsLogSummary.tpl

 

 

Michael A. DeLorenzo

Web: = www.oldecarriage.com

 


From: = Charles Kline [mailto:ckline@rightcode.net]
Sent: Tuesday, July 01, = 2008 9:37 AM
To: = <talk@webdna.us>
Subject: Re: [WebDNA] = Basic Search

 

use a counter. if you give a little more detail I can give = better advice, but you could do like...

[math]counter=3D0[/math]

[search]

[founditems]

[math]counter=3Dcounter+1/math[]

[/founditems]

[/search

--

Charles Kline


On Jul 1, 2008, at 9:29 AM, "Michael A. DeLorenzo" <michael@oldecarriage.com>= wrote:

But then the numfound number will be incorrect. Any other = ideas?

 

Michael A. = DeLorenzo

www.oldecarriage.com

 


From: Charles Kline [mailto:ckline@rightcode.net]
Sent: Tuesday, July 01, = 2008 9:21 AM
To: <talk@webdna.us>
Subject: Re: [WebDNA] = Basic Search

 

I'd = just filter the results. Just use a = hideif. 

 


On Jul 1, 2008, at 8:53 AM, "Michael A. DeLorenzo" <michael@oldecarriage.com>= wrote:

Hi = all,

 

I have not used WebDNA for a while (but damn glad to be back) and have stumbled = into a roadblock.

 

I have a custom log file and I am trying to summarize the number of hits to a = single page but wish to exclude all the recorded hits from any ip address = beginning with 192. I know I can do it with math but isn’t there an easier = way. Something along the lines = of:

 

[search db=3DLog.db&eqskudatarq=3D[sku]&neipaddressbw=3D192]=

    &nbs= p;       [numfound]

[/search]

 

Thanks for any help you may have to = offer.

 

Mike

 

 

------=_NextPart_000_04C2_01C8DB61.258939C0-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Basic Search - Fix ("David Bastedo" 2008)
  2. RE: [WebDNA] Basic Search - Fix ("Michael A. DeLorenzo" 2008)
  3. Re: [WebDNA] Basic Search - Fix ("David Bastedo" 2008)
  4. Re: [WebDNA] Basic Search - Fix (Donovan Brooke 2008)
  5. Re: [WebDNA] Basic Search - Fix (Terry Wilson 2008)
  6. RE: [WebDNA] Basic Search (Terry Wilson 2008)
  7. RE: [WebDNA] Basic Search ("Michael A. DeLorenzo" 2008)
  8. RE: [WebDNA] Basic Search (Terry Wilson 2008)
  9. RE: [WebDNA] Basic Search ("Michael A. DeLorenzo" 2008)
  10. RE: [WebDNA] Basic Search ("Michael A. DeLorenzo" 2008)
  11. Re: [WebDNA] Basic Search (Terry Wilson 2008)
  12. RE: [WebDNA] Basic Search (Terry Wilson 2008)
  13. Re: [WebDNA] Basic Search (Alex McCombie 2008)
  14. Re: [WebDNA] Basic Search (Charles Kline 2008)
  15. Re: [WebDNA] Basic Search (Charles Kline 2008)
  16. Re: [WebDNA] Basic Search (Alex McCombie 2008)
  17. RE: [WebDNA] Basic Search (Terry Wilson 2008)
  18. RE: [WebDNA] Basic Search ("Michael A. DeLorenzo" 2008)
  19. Re: [WebDNA] Basic Search (Charles Kline 2008)
This is a multi-part message in MIME format. ------=_NextPart_000_04C2_01C8DB61.258939C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Should I change the text variable to a math variable as just suggested? And do I need the show=f in it? Mike _____ From: Michael A. DeLorenzo [mailto:michael@oldecarriage.com] Sent: Tuesday, July 01, 2008 9:54 AM To: talk@webdna.us Subject: RE: [WebDNA] Basic Search OK almost there but something is duplicating things. Here is the code so far. Not that I am trying to do this in an embedded search. The first search goes into my database which holds my pages, each of which has a unique sku and fides all of the pages. The next search takes the sku of each page and searches the log file and tries to summarize the number of hits to that page (identified by sku) but the final count for each page can not include the hits from any ip address beginning with 192, thus the hideif. [text]hitcount=0[/text] [search db=../dbs/oldecarriage.db&neskudatarq=0] [founditems] [sku] has had [search db=listingsLog.db&eqskudatarq=[sku]] [founditems] [hideif [ipaddress]~192][text]hitcount=[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Here are the results http://72.242.199.250/oldecarriage/logs/listingsLogSummary.tpl Michael A. DeLorenzo Web: www.oldecarriage.com _____ From: Charles Kline [mailto:ckline@rightcode.net] Sent: Tuesday, July 01, 2008 9:37 AM To: Subject: Re: [WebDNA] Basic Search use a counter. if you give a little more detail I can give better advice, but you could do like... [math]counter=0[/math] [search] [founditems] [math]counter=counter+1/math[] [/founditems] [/search -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 9:29 AM, "Michael A. DeLorenzo" wrote: But then the numfound number will be incorrect. Any other ideas? Michael A. DeLorenzo www.oldecarriage.com _____ From: Charles Kline [mailto:ckline@rightcode.net] Sent: Tuesday, July 01, 2008 9:21 AM To: Subject: Re: [WebDNA] Basic Search I'd just filter the results. Just use a hideif. -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 8:53 AM, "Michael A. DeLorenzo" < michael@oldecarriage.com> wrote: Hi all, I have not used WebDNA for a while (but damn glad to be back) and have stumbled into a roadblock. I have a custom log file and I am trying to summarize the number of hits to a single page but wish to exclude all the recorded hits from any ip address beginning with 192. I know I can do it with math but isn't there an easier way. Something along the lines of: [search db=Log.db&eqskudatarq=[sku]&neipaddressbw=192] [numfound] [/search] Thanks for any help you may have to offer. Mike ------=_NextPart_000_04C2_01C8DB61.258939C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Should I change the text variable = to a math variable as just suggested? And do I need the show=3Df in = it?

 

Mike

 


From: = Michael A. DeLorenzo [mailto:michael@oldecarriage.com]
Sent: Tuesday, July 01, = 2008 9:54 AM
To: talk@webdna.us
Subject: RE: [WebDNA] = Basic Search

 

OK almost there but something is duplicating things. Here is the code so = far.

 

Not that I am trying to do this in = an embedded search. The first search goes into my database which holds my = pages, each of which has a unique sku and fides all of the pages. The next = search takes the sku of each page and searches the log file and tries to = summarize the number of hits to that page (identified by sku) but the final count for = each page can not include the hits from any ip address beginning with 192, = thus the hideif.

 

[text]hitcount=3D0[/text]=

[search db=3D../dbs/oldecarriage.db&neskudatarq=3D0]=

      =       [founditems]

      =       [sku] has had

      =             &= nbsp;     [search = db=3DlistingsLog.db&eqskudatarq=3D[sku]]

=

      =             &= nbsp;           &n= bsp;     [founditems]

      =             &= nbsp;           &n= bsp;           &nb= sp;     [hideif = [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif= ]

      =             &= nbsp;           &n= bsp;     [/founditems]

      =             &= nbsp;     [/search]

      =       [hitcount] page views.<br>

      =       [/founditems]

[/search]

 

Here are the results h= ttp://72.242.199.250/oldecarriage/logs/listingsLogSummary.tpl

 

 

Michael A. DeLorenzo

Web: = www.oldecarriage.com

 


From: = Charles Kline [mailto:ckline@rightcode.net]
Sent: Tuesday, July 01, = 2008 9:37 AM
To: = <talk@webdna.us>
Subject: Re: [WebDNA] = Basic Search

 

use a counter. if you give a little more detail I can give = better advice, but you could do like...

[math]counter=3D0[/math]

[math]counter=3Dcounter+1/math[]

[/founditems]

[/search

--

Charles Kline


On Jul 1, 2008, at 9:29 AM, "Michael A. DeLorenzo" <michael@oldecarriage.com>= wrote:

But then the numfound number will be incorrect. Any other = ideas?

 

Michael A. = DeLorenzo

www.oldecarriage.com

 


From: Charles Kline [mailto:ckline@rightcode.net]
Sent: Tuesday, July 01, = 2008 9:21 AM
To: <talk@webdna.us>
Subject: Re: [WebDNA] = Basic Search

 

I'd = just filter the results. Just use a = hideif. 

 


On Jul 1, 2008, at 8:53 AM, "Michael A. DeLorenzo" <michael@oldecarriage.com>= wrote:

Hi = all,

 

I have not used WebDNA for a while (but damn glad to be back) and have stumbled = into a roadblock.

 

I have a custom log file and I am trying to summarize the number of hits to a = single page but wish to exclude all the recorded hits from any ip address = beginning with 192. I know I can do it with math but isn’t there an easier = way. Something along the lines = of:

 

[search db=3DLog.db&eqskudatarq=3D[sku]&neipaddressbw=3D192]=

    &nbs= p;       [numfound]

[/search]

 

Thanks for any help you may have to = offer.

 

Mike

 

 

------=_NextPart_000_04C2_01C8DB61.258939C0-- "Michael A. DeLorenzo"

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:

TCP Connect (1999) Affiliate Marketing Question #2 (1998) disappearing SKU (etc.) fields (1998) Keep away (1997) Too Much Rootbeer Free Offer (1997) Plugin or CGI or both (1997) Updating a database once per day - An example (1998) [WebDNA] [WSC] WebDNA Development Summit (2014) WCS Newbie question (1997) Need relative path explanation (1997) New command suggestion (was Modifying databasesmanually) (1997) Tip: Image Maps (Server-Side) with WebCatalog (1997) Online reference (1997) Max Record length (1997) [input] [/input] (1997) relogin same user? (1998) Showif Context combined with Search (1997) Emailer [cart] file names (1997) [WriteFile] problems (1997) RE: [WebDNA] WebSite Examples (2008)