Re: One of us can't count....

2011-02-23 Thread Tim Bunce
On Mon, Feb 21, 2011 at 11:49:58AM -0800, Chad Wallace wrote: On Mon, 21 Feb 2011 11:11:09 -0700 Bruce Johnson john...@pharmacy.arizona.edu 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

Re: One of us can't count....

2011-02-21 Thread Bruce Johnson
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

Re: One of us can't count....

2011-02-21 Thread Bruce Johnson
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 populated, leading

Re: One of us can't count....

2011-02-21 Thread Chad Wallace
On Mon, 21 Feb 2011 11:11:09 -0700 Bruce Johnson john...@pharmacy.arizona.edu 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

Re: One of us can't count....

2011-02-21 Thread Bruce Johnson
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 no value for that

One of us can't count....

2011-02-18 Thread Bruce Johnson
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

Re: One of us can't count....

2011-02-18 Thread Bill Ward
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:

Re: One of us can't count....

2011-02-18 Thread Bruce Johnson
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

RE: One of us can't count....

2011-02-18 Thread Furst, Carl
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 should call do($sql, undef, @args

RE: One of us can't count....

2011-02-18 Thread Furst, Carl
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($sql, undef, @args

Re: One of us can't count....

2011-02-18 Thread Bruce Johnson
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: One of us can't count No, this is done as: $csr=$dbh-prepare($sql

Re: One of us can't count....

2011-02-18 Thread Bruce Johnson
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: (some

Re: One of us can't count....

2011-02-18 Thread Bruce Johnson
-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($sql, undef, @args