RE: [WebDNA] Basic Search
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100089
interpreted = N
texte = Move the first text variable so it's at the=20 beginning of each founditem. Otherwise each sku=20 is added to the previous one. This way it is=20 reset each time. [search db=3D../dbs/oldecarriage.db&neskudatarq=3D0] [founditems] [text]hitcount=3D0[/text] [sku] has had [search db=3DlistingsLog.db&eqskudatarq=3D[sku]] [founditems] =20 [hideif=20 [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Terry OK almost there but something is duplicating things. Here is the code so far= =2E Not that I am trying to do this in an embedded=20 search. The first search goes into my database=20 which holds my pages, each of which has a unique=20 sku and fides all of the pages. The next search=20 takes the sku of each page and searches the log=20 file and tries to summarize the number of hits to=20 that page (identified by sku) but the final count=20 for each page can not include the hits from any=20 ip address beginning with 192, thus the hideif. [text]hitcount=3D0[/text] [search db=3D../dbs/oldecarriage.db&neskudatarq=3D0] [founditems] [sku] has had [search db=3DlistingsLog.db&eqskudatarq=3D[sku]] [founditems] =20 [hideif=20 [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Here are the results=20
http://72.24= 2.199.250/oldecarriage/logs/listingsLogSummary.tpl Michael A. DeLorenzo Web: www.oldecarriage.com =46rom: 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=20 can give better advice, but you could do like... [math]counter=3D0[/math] [search] [founditems] [math]counter=3Dcounter+1/math[] [/founditems] [/search -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 9:29 AM, "Michael A.=20 DeLorenzo"=20 <michael@oldecarriage.com>=20 wrote: But then the numfound number will be incorrect. Any other ideas? Michael A. DeLorenzo www.oldecarriage.com =46rom: 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. -- Charles Kline <>ckline@rightcode.net <>http://www.rightcode.net On Jul 1, 2008, at 8:53 AM, "Michael A.=20 DeLorenzo" <<>michael@oldecarriage.com> wrote: Hi all, I have not used WebDNA for a while (but damn glad=20 to be back) and have stumbled into a roadblock. I have a custom log file and I am trying to=20 summarize the number of hits to a single page but=20 wish to exclude all the recorded hits from any ip=20 address beginning with 192. I know I can do it=20 with math but isn=B9t there an easier way.=20 Something along the lines of: [search db=3DLog.db&eqskudatarq=3D[sku]&neipaddressbw=3D192] [numfound] [/search] Thanks for any help you may have to offer. Mike -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
Move the first text variable so it's at the=20 beginning of each founditem. Otherwise each sku=20 is added to the previous one. This way it is=20 reset each time. [search db=3D../dbs/oldecarriage.db&neskudatarq=3D0] [founditems] [text]hitcount=3D0[/text] [sku] has had [search db=3DlistingsLog.db&eqskudatarq=3D[sku]] [founditems] =20 [hideif=20 [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Terry OK almost there but something is duplicating things. Here is the code so far= =2E Not that I am trying to do this in an embedded=20 search. The first search goes into my database=20 which holds my pages, each of which has a unique=20 sku and fides all of the pages. The next search=20 takes the sku of each page and searches the log=20 file and tries to summarize the number of hits to=20 that page (identified by sku) but the final count=20 for each page can not include the hits from any=20 ip address beginning with 192, thus the hideif. [text]hitcount=3D0[/text] [search db=3D../dbs/oldecarriage.db&neskudatarq=3D0] [founditems] [sku] has had [search db=3DlistingsLog.db&eqskudatarq=3D[sku]] [founditems] =20 [hideif=20 [ipaddress]~192][text]hitcount=3D[math][hitcount]+1[/math][/text][/hideif] [/founditems] [/search] [hitcount] page views.
[/founditems] [/search] Here are the results=20 http://72.24= 2.199.250/oldecarriage/logs/listingsLogSummary.tpl Michael A. DeLorenzo Web: www.oldecarriage.com =46rom: 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=20 can give better advice, but you could do like... [math]counter=3D0[/math] [search] [founditems] [math]counter=3Dcounter+1/math[] [/founditems] [/search -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 1, 2008, at 9:29 AM, "Michael A.=20 DeLorenzo"=20 <michael@oldecarriage.com>=20 wrote: But then the numfound number will be incorrect. Any other ideas? Michael A. DeLorenzo www.oldecarriage.com =46rom: 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. -- Charles Kline <>ckline@rightcode.net <>http://www.rightcode.net On Jul 1, 2008, at 8:53 AM, "Michael A.=20 DeLorenzo" <<>michael@oldecarriage.com> wrote: Hi all, I have not used WebDNA for a while (but damn glad=20 to be back) and have stumbled into a roadblock. I have a custom log file and I am trying to=20 summarize the number of hits to a single page but=20 wish to exclude all the recorded hits from any ip=20 address beginning with 192. I know I can do it=20 with math but isn=B9t there an easier way.=20 Something along the lines of: [search db=3DLog.db&eqskudatarq=3D[sku]&neipaddressbw=3D192] [numfound] [/search] Thanks for any help you may have to offer. Mike -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
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:
forming a SKU (1999)
WebCat 2.1.3 (and docs) (1998)
Hideifs / Showifs (2000)
WebTen and WebCat (1997)
Translator. (1998)
TaxTotal Problem (1997)
2.0 Info (1997)
Odd search results, or odd programmer, not sure which... (2002)
Search returns all, not 20 (1997)
Auto-closing of databases (was DON'T use old cart file!) (1997)
Include a big block of text (1997)
WebCatalog for Postcards ? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WebCat2 - [format thousands] (1997)
WebCat2 beta 11 - new prefs ... (1997)
Tab Charactor (1997)
Help formatting search results w/ table (1997)
[WebDNA] Triggers not working (2011)
e-commerce recommendation update... (2004)
Calendar (1997)