OT: PreparedStatement with dynamic parameter list

["Chakravarthy, Sundar" <sc...@doas.ga.gov>]

Has anyone constructed a PreparedStatement where the number of ?s ( i.e
bind variables ) is unknown at compile time  ?

Is there any support of that in JDBC ?

Thanks

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: OT: PreparedStatement with dynamic parameter list

[John Turner <to...@johnturner.com>]

The SQL parameter passed to java.sql.Connection.preparedStatement() is a 
String.  You can write whatever logic you want to build that string, 
including counting the number of arguments obtained from somewhere else and 
building the right number of placeholders accordingly.  Probably won't be 
very elegant, but certainly possible.

John

On Tue, 1 Apr 2003 10:36:14 -0500, Chakravarthy, Sundar 
<sc...@doas.ga.gov> wrote:

>
> Has anyone constructed a PreparedStatement where the number of ?s ( i.e
> bind variables ) is unknown at compile time  ?
>
> Is there any support of that in JDBC ?
>
> Thanks
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org