Re: Binding input parameters in DB2

2002-01-08 Thread Tim Bunce
On Tue, Jan 08, 2002 at 10:00:06AM -0600, s1ider wrote: > > > Not reading your code before posting it: > > > > > my $sth100->prepare( "SELECT TABLELISTSEQ FROM db2inst1.SWP_TABLELIST WHERE >TABLELIST = $quote_listvalues" ); > > I am very sorry if I am totally confused about what I am doing S

Re: Binding input parameters in DB2

2002-01-08 Thread s1ider
On Tue, 8 Jan 2002 03:27:51 -0500 Terrence Brannon <[EMAIL PROTECTED]> wrote: > > where is line 74? > Line 74 is $sth->execute(); It is the execute line inside the of my bind/for loop. On Tue, 8 Jan 2002 11:01:28 + Tim Bunce <[EMAIL PROTECTED]> wrote: > Not reading your code before postin

Re: Binding input parameters in DB2

2002-01-08 Thread Tim Bunce
On Mon, Jan 07, 2002 at 09:54:40PM -0600, s1ider wrote: > What am I doing wrong? Not reading your code before posting it: > my $sth100->prepare( "SELECT TABLELISTSEQ FROM db2inst1.SWP_TABLELIST WHERE >TABLELIST = $quote_listvalues" ); Tim.

Re: Binding input parameters in DB2

2002-01-08 Thread Terrence Brannon
On Monday, January 7, 2002, at 10:54 PM, s1ider wrote: > What am I doing wrong? I have followed the perldoc DBD::DB2 and even > [Fri Jan 6 22:58:11 2002] [error] Can't call method "prepare" on > an undefined value at /usr/perl/cgi/permit_organization.cgi line > 74. > > where is line 74?

Binding input parameters in DB2

2002-01-07 Thread s1ider
What am I doing wrong? I have followed the perldoc DBD::DB2 and even copies the example from the documentation (no plagerism intended =) ) I have have no problems sending the information to the database if I don't use databinding. I would really really prefer to use databinding in the loop i