[Zope] A single value from SQL

Rob Page rob.page@digicool.com
Sat, 5 Jun 1999 12:45:47 -0400


> So there isn't a way to directly call one ZSQLMethod from 
> another, then.

I just tried this (and it worked!) with a simple Gadfly database:

SELECT * FROM employees 
WHERE 
age = 
<!--#in sqlSelectOldestAge-->
<!--#var oldest_age-->
<!--#/in-->

where sqlSelectOldestAge:
----------------------------
SELECT MAX(age) AS oldest_age FROM employees

--Rob