you have to pass variables explicitly to zsql methods, like <dtml-var "test_for_page_count(url=url)"> afaik this is for security reasons On Sat, 27 Oct 2001, Python wrote:
hi all: I red an article about "SQL Page Counter" in "Zope how-to", i implement it with Z gadfly database connection instead of POSTGRES database.
but i found the "url" varible defined cound not forward to let ZSQL method know.
<dtml-call "REQUEST.set('url', URL0)"> <dtml-in test_for_page_count>
<dtml-if "count>=1"> <dtml-call update_page_count> <dtml-in getPageViews> <center> This page has been viewed <b><dtml-var count></b> times. </center> </dtml-in> <dtml-else> <dtml-call initialize_page_count> <dtml-in getPageViews> <center> This page has been viewed <b><dtml-var count></b> time. </center> </dtml-in> </dtml-if> </dtml-in>
but "test_for_page_count" ZSQL method could not "url"'s value.
how could this happen?
here is his implementation :
First set up a database, and a database connection. Then create your table. I called mine "countpages":
--- SQL METHOD "create_table" --- CREATE TABLE countpages ( count INT4, url VARCHAR(255) )
Then, you'll need a few SQl methods:
--- SQL METHOD "test_for_page_count" --- ARGUMENTS: url ---------------------------------------- SELECT count(count) FROM countpages WHERE url = <dtml-sqlvar url type=nb>
--- SQL METHOD "getPageViews" --- ARGUMENTS: url ---------------------------------------- select * from countpages WHERE url = <dtml-sqlvar url type=nb>
--- SQL METHOD "update_page_count" --- ARGUMENTS: url ---------------------------------------- UPDATE countpages SET count = count + 1 WHERE url = <dtml-sqlvar url type=nb>
--- SQL METHOD "initialize_page_count" --- ARGUMENTS: url ---------------------------------------- INSERT INTO countpages ( count, url ) VALUES ( 1, <dtml-sqlvar url type=nb> )
Then, place this DTML in your standard_html_footer (or whereever you want the count to show up.
<dtml-comment>
### PAGE COUNT TOOLKIT ###
### Test to see if this page exists in the database ### If it does, update the count and display it. ### If not, create a record for it, and display that.
</dtml-comment>
<dtml-call "REQUEST.set('url', URL0)"> <dtml-in test_for_page_count>
<dtml-if "count>=1"> <dtml-call update_page_count> <dtml-in getPageViews> <center> This page has been viewed <b><dtml-var count></b> times. </center> </dtml-in> <dtml-else> <dtml-call initialize_page_count> <dtml-in getPageViews> <center> This page has been viewed <b><dtml-var count></b> time. </center> </dtml-in> </dtml-if> </dtml-in> <BR><BR>
<dtml-comment> ### END PAGE COUNT TOOLKIT ### </dtml-comment>
I found that ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÙ¢¦j)eËÿf^ÿ:){ú+m§ÿÿ+-³üè¥ïè®æj)fjåËbú?Î^ÿóhrº,²,¶Ê+ 3 zw(v)àÿÿÿEéZµçeËlþm§ÿÿ+-³üè¥ïè®æj)fjåËbú?Î^ý©ç¢éÜzm§ÿÿ+-³üè¥ïè®æj)fjåËbú?Î^ýׯ
-- _________________________________________________ peter sabaini, mailto: sabaini@niil.at -------------------------------------------------