[Zope] How can I let ZSQL method know the variable i define.

27 Oct 2001

      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 <dtml-var count> times. 
</center>
</dtml-in>
<dtml-else>
<dtml-call initialize_page_count>
<dtml-in getPageViews>
<center>
This page has been viewed <dtml-var count> 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 <dtml-var count> times. 
</center>
</dtml-in>
<dtml-else>
<dtml-call initialize_page_count>
<dtml-in getPageViews>
<center>
This page has been viewed <dtml-var count> time. 
</center>
</dtml-in>
</dtml-if>
</dtml-in>

<dtml-comment>
### END PAGE COUNT TOOLKIT ###
</dtml-comment>

I found that

[Zope] How can I let ZSQL method know the variable i define.

Python