Re: Select Multiple Form Field via Perl into Oracle error

I tried this already but have since discovered an odd character in there but have no idea what it is - i've tried eplacing all \t, \r, \v, \b, \n, \f characters but it aint on of them. Anyone got a way to interpret or convert characters in a string to a readable format for stripping out in Perl?

Thanks

Ian

Makarand Kulkarni <makkulka_at_cisco.com> wrote in message 37C4853F.8B788040_at_cisco.com...
>[ Simmo wrote:
>
>> my $sql = qq{ $SQL1 };
>> my $sth=$dbh->prepare( $sql );
>> $sth->execute();
>
>A check you can do here is to print $sql before it is passed to prepare().
If
>prepare() complains then hand over this query string ( without the
enclosing
>quotes if any ) to SQLplus and see what error it complains about.
>--
>
>
Received on Thu Aug 26 1999 - 10:16:24 CDT