On Friday, Jan 17, 2003, at 10:04 Europe/London, Carsten Ziegeler wrote:
Jeremy Quinn wrote:
SELECT DISTINCT contributor_id, name FROM foo WHERE
contributor_id =
<substitute-value sql:name="contributor_id"/>
this is how mine look ...
And you do not use the sql namespace on the substitue-value element
(sql:substitue-value sql:name="..."/>) or have the default namespace
set to sql?
yeah, I missed that ;) Whoops!
you need to declare the prefixed namespace if you want to use either:
<substitue-value sql:name="id"/>
or
<ancestor-value sql:name="id" sql:level="1"/>
<execute-query
xmlns="http://apache.org/cocoon/SQL/2.0"
xmlns:sql="http://apache.org/cocoon/SQL/2.0"
>
<query>
select *
from blah
where id = <substitue-value sql:name="id"/>
</query>
</execute-query>
Sorry!!
regards Jeremy
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>