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 >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
