Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 89318 invoked from network); 1 Apr 2003 15:53:34 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 1 Apr 2003 15:53:34 -0000 Received: (qmail 4226 invoked by uid 97); 1 Apr 2003 15:55:24 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 4218 invoked from network); 1 Apr 2003 15:55:24 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 1 Apr 2003 15:55:24 -0000 Received: (qmail 84226 invoked by uid 500); 1 Apr 2003 15:52:27 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 84163 invoked from network); 1 Apr 2003 15:52:26 -0000 Received: from mail.plumcreek.com (HELO cfo-msg.plumcreek.net) (208.4.182.150) by daedalus.apache.org with SMTP; 1 Apr 2003 15:52:26 -0000 Received: from plumcreek-MTA by cfo-msg.plumcreek.net with Novell_GroupWise; Tue, 01 Apr 2003 08:52:18 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.2 Date: Tue, 01 Apr 2003 08:52:08 -0700 From: "Larry Meadors" To: Subject: Re: OT: PreparedStatement with dynamic parameter list Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Here are a couple of options for this: The open-source ibatis database framework (www.ibatis.com) lets you do this. Another home-grown solution would be to create a StringBuffer for your SQL, and a map for the parameters. Then you can prepare the statement, and iterate through the map setting the parameters. Larry >>> schakravarthy@doas.ga.gov 04/01/03 08:37 AM >>> Has anyone constructed a PreparedStatement where the number of ?s ( i.e bind variables ) is unknown at compile time ? --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org