On Oct 18, 2001 at 04:03 -0700, Matt Klicka took the soap box and proclaimed:
: I'm trying to enter data into MySQL and can't seem to
: be able to enter the question mark and the quote
: characters. I've tried every way of quoting (and
: backslashing) I can think of to no avail. With the
: quote I get an error from MySQL saying the query was
: bad (i.e. the query ended at the quote) and with the
: question mark it gets entered as a funky block that,
: when read from mysql and printed by perl, is "NULL".
: This is probably more of a MySQL question than perl
: but I haven't been able to find anything in any of the
: MySQL documentation about it so I'm not so sure.
Are you using the $dbh->quote() method? This will quote data to the
underlying databases requirements.
my $data = $dbh->quote( $rawdata );
$sth->do( "INSERT INTO foo VALUES $data" );
Casey West
--
"Drill for oil? You mean drill into the ground to try and find oil?
You're crazy."
-- Drillers who Edwin L. Drake tried to enlist to his project to
drill for oil in 1859.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
