Hi Brady -- Unfortunately, I'm not too familiar with our DBTags library, but JSTL EA3 (and future versions) should support what you're trying to do. Take a look at the Standard Taglib's "sql" library and let us know if you've got any questions.
Best, -- Shawn Bayern JSTL reference-implementation lead Author, "JSP Standard Tag Library" (Manning, upcoming) http://jstlbook.com On Tue, 29 Jan 2002, Brady Moritz wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>