'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
