Use $dbh->trace(...) and study what it says.
Tim.
On Thu, Apr 18, 2002 at 08:38:59AM -0400, Chris Fuhrman wrote:
>
> 'Morning,
>
> Well, I changed my code to the following:
>
> /^a_type/ && do {
> foreach $position (keys
> $bighash->{"a_type"}) {
>
> $cdr[$position] =~ s/\'/-/g;
>
> $sth->bind_param($position + 1,
> $cdr[$position],
> SQL_CHAR);
>
> } # foreach $position (keys ... )
> last TYPE;
> }; # Alphanumeric processing
>
> and then changed the execute statement to:
>
> $sth->execute();
>
> You'll also notice that I'm no longer referencing the $sth hash via a
> referant (tried to see if that was causing it).
>
> No luck. I'm still getting spaces clobbered :(
>
> Some other actions I've tried:
>
> - upgraded to DBI-1.21 and DBD-Oracle-1.12
> - recompiled DBI with the -8 option to force OCI 7 compatibility
> - switched the SQL_CHAR to SQL_VARCHAR
> - commented out the s/\'/\-/g from the code above
>
> I'm storing $sth in a large hash with some other values. What I do is
> based on the string I'm processing and some other information, I pull out
> the appropriate $sth from the hash and use that to insert my textstring.
>
> I've also added debugging so I *know* the strings going into the bind are
> correct.
>
> I'm going to play around with some other test scripts. I've another basic
> test-script that works forwhatever reason and I need to figure out the
> magic "difference" that causes the functionality to break.
>
> Other ideas or comments would be more than welcome!
>
> Cheers!
>
>
> On Wed, 17 Apr 2002, Gaul, Ken wrote:
>
> >
> > If you are calling bind_param you don't need to call execute with parameters
> > this will rebind using the defaults. take out @cdr of the execute line and
> > see if that works.
> >
> > Ken.
> >
>
> --
> Chris Fuhrman | Twenty First Century Communications
> [EMAIL PROTECTED] | Software Engineer
> (W) 614-442-1215 x271 |
> (F) 614-442-5662 | PGP/GPG Public Key Available on Request
>
