Hi everyone, Im new to the list so good to meet you.
Any pointers on why the following code is disallowed, and a quick way to
code around it? Apparently prepared statements do not allow run-time
resolution of the query string.
<sql:query>
select * from orders where <%= where %>
//"where" contains the where clause, with columnname=?
repeated.
//this build a dynamic query with varying number of
elements
</sql:query>
<sql:execute>
<% for(int i = 0; i< val.size(); i++){ %>
<sql:setColumn position="<%
out.write(String.valueOf(i)); %>">
<%= val.elementAt(0) %></sql:setColumn>
<% } %>
</sql:execute>
Brady Moritz
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
