Two SQL taglib questions

[Ulrich Mayring <ul...@denic.de>]

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