Jacobien,
Try this:
my $blob = $record->as_usmarc();
$blob= $dbh->quote($blob);
And load $blob as you did before.
Leif
==
Leif Andersson, Systems Librarian
Stockholm University Library
SE-106 91 Stockholm
SWEDEN
The error message is:
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 's principles and practice of medicine. a616
DAY MEDbcfkmnpqxNz1100 ' at line 1 at ./blob2.pl line 146.
When
What's the exact error message?
//Ed
Hi
I'm dumping the whole marc record in one column, in a mysql database. I
created a table with a blob column. But, when a singe quote ' appears
somewhere in a record, the record can't be loaded into the mysql. I
receive a syntax error. Does anyone know of a solution?
Jacobien Stols
Developer
Sys
