[WebDNA] Issue with [table] append and search from, ...
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 113111
interpreted = N
texte = 699 Good evening all Hoping to get some help to identify what I am not able to see myself. Basically I have a DB (=E2=80=9Cviews=E2=80=9D) which contains a = one-line-reg of every time a user clicks and reads an article. These = logs are only stored for approx 10 days so the content of the DB is = quite limited as it is clean up regularly. Well, I do a search to find all of thes logs, an I summarise to I only = get on result from any article ID. I then create a table which stores 3 = values; an Id, the article ID and the amount of time this ID is actual = found in the DB. The last action is performed by doing a search in the = DB and calculating the result (amount of time the article ID is found). = This seem to be executing fine when I run the code, but when I do a = search and print of the Table I only get garbage, actually it only shows = a result of to article id=E2=80=99s which are the same, though it should = display 10 unique article ID=E2=80=99s and the following calculations of = how many times this article ID is being clicked/logged. Any clue where I am doing wrong? The code below includes some debug text and
to clean up result. I think there is a typo but can=E2=80=99t find it. /Palle [search = db=3D/databases/views.db&eqhits_statusdata=3D1&dehits_indexsort=3D1&hits_i= ndextype=3Dnum&allreqd=3DT&hits_articleSumm=3Dt][numFound] Article ID's = found (SUMM)
[founditems]
Article ID: [hits_article], found: [table name=3Darticle_views&fields=3Df1,f2,f3][/table] [search = db=3D/databases/views.db&eqhits_articledata=3D[hits_article]] [text show=3Dt]fvolume=3D[numFound][/text] [founditems] =09
Output Debug: [hits_index] - [hits_article] = - [fvolume] [append = table=3Darticle_views]&f1=3D[url][hits_index][/url]&f2=3D[url][hits_articl= e][/url]&f3=3D[url][fvolume][/url][/append] [/founditems] [/search]
[/founditems] [/search]
--
Search and Print the content of the = Table ("article_views") [search table=3Darticle_views&nef1data=3D[blank]][numFound] [founditems]
[f1]::[f2]::[f3] [/founditems] [/search]= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
699 Good evening all Hoping to get some help to identify what I am not able to see myself. Basically I have a DB (=E2=80=9Cviews=E2=80=9D) which contains a = one-line-reg of every time a user clicks and reads an article. These = logs are only stored for approx 10 days so the content of the DB is = quite limited as it is clean up regularly. Well, I do a search to find all of thes logs, an I summarise to I only = get on result from any article ID. I then create a table which stores 3 = values; an Id, the article ID and the amount of time this ID is actual = found in the DB. The last action is performed by doing a search in the = DB and calculating the result (amount of time the article ID is found). = This seem to be executing fine when I run the code, but when I do a = search and print of the Table I only get garbage, actually it only shows = a result of to article id=E2=80=99s which are the same, though it should = display 10 unique article ID=E2=80=99s and the following calculations of = how many times this article ID is being clicked/logged. Any clue where I am doing wrong? The code below includes some debug text and
to clean up result. I think there is a typo but can=E2=80=99t find it. /Palle [search = db=3D/databases/views.db&eqhits_statusdata=3D1&dehits_indexsort=3D1&hits_i= ndextype=3Dnum&allreqd=3DT&hits_articleSumm=3Dt][numFound] Article ID's = found (SUMM)
[founditems]
Article ID: [hits_article], found: [table name=3Darticle_views&fields=3Df1,f2,f3][/table] [search = db=3D/databases/views.db&eqhits_articledata=3D[hits_article]] [text show=3Dt]fvolume=3D[numFound][/text] [founditems] =09
Output Debug: [hits_index] - [hits_article] = - [fvolume] [append = table=3Darticle_views]&f1=3D[url][hits_index][/url]&f2=3D[url][hits_articl= e][/url]&f3=3D[url][fvolume][/url][/append] [/founditems] [/search]
[/founditems] [/search]
--
Search and Print the content of the = Table ("article_views")
[search table=3Darticle_views&nef1data=3D[blank]][numFound] [founditems]
[f1]::[f2]::[f3] [/founditems] [/search]= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us .
Palle Bo Nielsen
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:
placement of ? (2000)
NewCart+Search with one click ? (1997)
Search in 2 or more catalogs (1997)
WebCatalog can't find database (1997)
encrypt method=APOP broken or just not enough docs? - was:MD5 encryption (2003)
PCS Emailer's role ? (1997)
Shopping Carts (2000)
Safari browser and WebDNA set-cookies (2003)
Sorting Numbers (1997)
[SHOWNEXT] Examples (1997)
Ariba XML support help needed (2004)
quit command on NT (1997)
WebCat & WebTen (1997)
Only charge card when product shipped ? (1997)
too many nested [xxx] (1997)
Suffix or Line? (1999)
nested showif? (1998)
Make sure I understand this??? (1997)
YACBQ.....(Yet another checkbox question) (2000)
database problem (2003)