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:
Safari browser and WebDNA set-cookies (2003)
matching shipto and others (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
founditem align (1998)
authenticating a second user (1997)
Newbie needs advice to learn to use WebDNA (2003)
WebCatalog can't find database (1997)
Error 551 in Emailer (2000)
Calculating Shipping (1997)
Database Repopulation (2004)
problems with 2 tags shakur (1997)
$Quit, $CloseDatabase corrections (1997)
Shopping carts and reloading pages (1997)
Summing fields (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Database cloning, or possible hack? (2003)
Header info in content (1998)
really wierd date stuff on NT (1997)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)