| Summary: | can't spefiy where clause dynamically in sql tag..... | ||
|---|---|---|---|
| Product: | Taglibs | Reporter: | Gogo <guoling> |
| Component: | Standard Taglib | Assignee: | Tomcat Developers Mailing List <dev> |
| Status: | RESOLVED INVALID | ||
| Severity: | critical | ||
| Priority: | P3 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
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. |
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