RE: [WebDNA] Basic Search
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100093
interpreted = N
texte = It's up to you. I find the simpler use of [math]=20 is less prone to typos, as there just just less=20 code. You don't need show=3Df with text variables,=20 but you do with math, if you don't want the=20 result to display on the webpage. As with a text=20 var, [hitcount] is all you need to retrieve the=20 math variable. Terry Should I change the text variable to a math=20 variable as just suggested? And do I need the=20 show=3Df in it? Mike =46rom: 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= =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:
It's up to you. I find the simpler use of [math]=20 is less prone to typos, as there just just less=20 code. You don't need show=3Df with text variables,=20 but you do with math, if you don't want the=20 result to display on the webpage. As with a text=20 var, [hitcount] is all you need to retrieve the=20 math variable. Terry Should I change the text variable to a math=20 variable as just suggested? And do I need the=20 show=3Df in it? Mike =46rom: 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= =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:
HEADER AND FOOTER (1997)
Not reading code (1997)
WebDNA and ASP on Same Server (2004)
deerfield/wingate server (2004)
WebCatalog can't find database (1997)
Odd search results, or odd programmer, not sure which... (2002)
Extended [ConvertChars] (1997)
RequiredFields parameter (1998)
problems with 2 tags shakur (1997)
Setting up shop (1997)
Verifying both name and password (was: THANKS) (1997)
Number of Feilds Passed to [append] (2000)
ASP and Web DNA (1998)
Running 2 two WebCatalog.acgi's (1996)
[WebDNA] Emailer breaking format (2015)
WebDNA dying or ... ? (2005)
color (1999)
Tcp connect (2002)
Generating Report Totals (1997)
[ShowNext] feature in 2.0 (1997)