Sorry to repeat, but does anyone have a clue on this or should I go about this a different way?
Brady Moritz -----Original Message----- From: Brady Moritz [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 6:01 AM To: 'Tag Libraries Users List' Subject: Hello, and need help 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
