On Mon, Feb 21, 2011 at 11:49:58AM -0800, Chad Wallace wrote:
> On Mon, 21 Feb 2011 11:11:09 -0700
> Bruce Johnson wrote:
>
> > On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
> >
> > > The error MESSAGE, however contained the last known value for that
> > > number bind variable, which may be
On Feb 21, 2011, at 11:20 AM, Bruce Johnson wrote:
>
> On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
>
>> On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
>>
>>> Figured it out.
>>>
>>> The second ldap query did not return all the attributes I was looking for,
>>> and when it returned
On Mon, 21 Feb 2011 11:11:09 -0700
Bruce Johnson wrote:
> On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
>
> > The error MESSAGE, however contained the last known value for that
> > number bind variable, which may be a bug.
>
> I wasn't quite correct, the error message actually lists the
> p
On Feb 21, 2011, at 11:11 AM, Bruce Johnson wrote:
> On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
>
>> Figured it out.
>>
>> The second ldap query did not return all the attributes I was looking for,
>> and when it returned no value for that attribute, the bind variable wasn't
>> populat
On Feb 18, 2011, at 1:55 PM, Bruce Johnson wrote:
> Figured it out.
>
> The second ldap query did not return all the attributes I was looking for,
> and when it returned no value for that attribute, the bind variable wasn't
> populated, leading to the mismatch between expected and actual. The
is, this is the second query to the LDAP server in the program, the
> first one, using identical DBI code, works.
>
> The only difference is the LDAP query.
>
> On Feb 18, 2011, at 1:10 PM, Furst, Carl wrote:
>
>> Are you calling $csr->finish at the end of each iterati
--
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, February 18, 2011 3:21 PM
Cc: dbi-users@perl.org
Subject: Re: One of us can't count
This is a quickie version of what I'm doing:
$sql ="insert into foo (bar, baz, buz) values(?,?,?)";
$csr = $dbh-
Tried it that way, same error.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
> You're probably calling do($sql, @args) when you should call do($sql, undef,
> @args)
>
> On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson <
> john...@pharmacy.arizona.edu> wrote:
>
>> I'm getting the following error
ndeed good practice.
>
> Carl Furst
> o/~ What a difference a byte makes... o/~
>
> -Original Message-
> From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
> Sent: Friday, February 18, 2011 3:07 PM
> Cc: DBI Users List (dbi-users@perl.org)
> Subject: Re:
List (dbi-users@perl.org)
Subject: Re: One of us can't count
No, this is done as:
$csr=$dbh->prepare($sql)
then as $csr->execute(@parms) inside of a loop.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
> You're probably calling do($sql, @args) when you should call do($
DBI Users List (dbi-users@perl.org)
Subject: Re: One of us can't count
No, this is done as:
$csr=$dbh->prepare($sql)
then as $csr->execute(@parms) inside of a loop.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
> You're probably calling do($sql, @args) when you shou
No, this is done as:
$csr=$dbh->prepare($sql)
then as $csr->execute(@parms) inside of a loop.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
> You're probably calling do($sql, @args) when you should call do($sql, undef,
> @args)
>
> On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson <
> john...@p
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson <
john...@pharmacy.arizona.edu> wrote:
> I'm getting the following error: (some data has been change to protect the
> bystanders.)
>
> DBD::Oracle::st execute failed
I'm getting the following error: (some data has been change to protect the
bystanders.)
DBD::Oracle::st execute failed: called with 18 bind variables when 19 are
needed [for Statement "insert into edsbase
(cn,emplId,employeeType,employeeTitle,employeeStatus,employeeTotalAnnualRate,sn,givenName,
14 matches
Mail list logo
