Bug 28324 - can't spefiy where clause dynamically in sql tag.....
Summary: can't spefiy where clause dynamically in sql tag.....
Status: RESOLVED INVALID
Alias: None
Product: Taglibs
Classification: Unclassified
Component: Standard Taglib (show other bugs)
Version: unspecified
Hardware: PC All
: P3 critical (vote)
Target Milestone: ---
Assignee: Tomcat Developers Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-10 04:17 UTC by Gogo
Modified: 2004-11-16 19:05 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gogo 2004-04-10 04:17:02 UTC
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
Comment 1 Felipe Leme 2004-04-14 02:45:18 UTC
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.