This is a multi-part message in MIME format.

------extPart_000_00EA_01C2D76B.3FC8EC40
Content-Type: text/plain;
	charsetso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
  Is there a way to execute a statement, passing in an array for the bind variables? If I use

sth.execute(array[0],array[1],array[2])

Everything works fine, but if I just use

sth.execute(array)

I get a 'not all variables bound' error. Am I missing something?


Marty

------extPart_000_00EA_01C2D76B.3FC8EC40
Content-Type: text/html;
	charsetso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4916.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Courier New" size=2>Hi,</FONT></DIV>
<DIV><FONT face="Courier New" size=2>&nbsp; Is there a way to execute a 
statement, passing in an array for the bind variables? If I use</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" 
size=2>sth.execute(array[0],array[1],array[2])</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2>Everything works fine, but if I just 
use</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2>sth.execute(array)</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2>I get a 'not all variables bound' error. Am 
I missing something?</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2></FONT>&nbsp;</DIV>
<DIV><FONT face="Courier New" size=2>Marty<BR></FONT></DIV></BODY></HTML>

------extPart_000_00EA_01C2D76B.3FC8EC40--