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º,²š,¶Ê+3zw(v)àÿÿÿEéZµçeŠËlþm§ÿÿ–+-³üè¥ïè®æj)fjåŠËbú?Ί^ý©ç¢éÜzm§ÿÿ–+-³üè¥ïè®æj)fjåŠËbú?Ί^ýׯ

-- _________________________________________________ peter sabaini, mailto: sabaini@niil.at -------------------------------------------------