cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ulrich Mayring <u...@denic.de>
Subject Two SQL taglib questions
Date Thu, 13 Apr 2000 08:49:27 GMT
Hello,

1.) I'm getting this error:

com.sybase.jdbc.SybSQLException: Incorrect syntax near '*'.

with this query:

<sql:query>select a.* from TA a, TB b where a.ID = b.ID</sql:query>

The same query string works as expected in SQL Processor, so I think it
is not a problem with the driver. Probably it receives something
different than what I wrote in the query string.


2.) How can I pass outside information into the query string? This
doesn't work:

<xsl:variable name="myvar" select="/userinput"/>
<sql:query>select * from TA where ID = {$myvar}</sql:query>


thanks a lot for any help,

Ulrich

-- 
Ulrich Mayring
DENIC eG, Systementwicklung

Mime
View raw message