[Zope] calling ZSQL "in place"

[Timothy Wilson]

Hi everyone,

I'd like to print the total number of records in a database table and
print that number on my page. My ZSQL method looks like:

SELECT COUNT(*) FROM foo_table

The method returns the correct number when I test it.

I'd like to print the following:

There are [insert SQL result here] records in the database.

Using <dtml-call "foo_sql(REQUEST)"> doesn't work. Ideas?

BTW, I've very impressed with the SQL tools that Zope has. Obviously, I'm
new to using SQL with Zope, but the Z Search Interface Wizard was an
absolute God-send. I'd be nowhere near as far along as I am without it.

Now if I could just find my Zen... :-)

-Tim

--
Timothy Wilson       | "The faster you  |  Check out:
Henry Sibley H.S.    |  go, the shorter | http://slashdot.org/
W. St. Paul, MN, USA |  you are."       | http://linux.com/
wilson@visi.com      |       -Einstein  | http://www.mn-linux.org/