I tried to specify the where clause at runtime use this: <sql:transaction dataSource="${conn}"> <sql:query var="deejay"> SELECT * FROM dwgl ?; <sql:param value="where orderno=1"/> </sql:query> </sql:transaction> but it seems <sql param> only accept values such as set=? values(1,?)...I think it's nessary to specify where clause or other parts of sql statement in the tag lib
Gogo, The SQL taglib is nothing more than an interface to JDBC calls and the JDBC doesn't allow what you're looking for. So, I'm marking this bug as invalid.