reSQL, but doesn't use any
Postgres-specific stuff, so it should be easy to convert for use with
MySQL).
-David Christensen
> -Original Message-
> From: bargioni [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 03, 2006 1:54 AM
> To: perl4lib@perl.org
> Subject: Re: P
On 02/gen/06, at 16:34, Dennis Boone wrote:
I am trying to clean up a raw MARC record for insertion in a MySQL
database. Here is my code:
$rec = $rec->rawdata();
$rec = $dbh->quote($rec);
I get the following error back:
DBD::mysql::st execute failed: You have an error in your SQL
syntax. C
> I am trying to clean up a raw MARC record for insertion in a MySQL
> database. Here is my code:
>
> $rec = $rec->rawdata();
> $rec = $dbh->quote($rec);
>
> I get the following error back:
>
> DBD::mysql::st execute failed: You have an error in your SQL
> syntax. Check the manual th
On Jan 1, 2006, at 7:47 PM, Aaron Huber wrote:
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 '02852cam 2200325Ia
45e00010008000500178008004100025010 at ./zlite.pl line 7
On 02/gen/06, at 05:50, Saiful Amin wrote:
Hi,
Another method could be to store MARC record as a blob. That's how many
library systems (including PHPMyLibrary) handles MARC data. However,
I'm
ignorant of the performance issues.
This is my opinion too. No problem with performances, I think.
Hi,
Another method could be to store MARC record as a blob. That's how many
library systems (including PHPMyLibrary) handles MARC data. However, I'm
ignorant of the performance issues.
Regards,
Saiful
On 1/2/06, Mark Jordan <[EMAIL PROTECTED]> wrote:
>
> Hi Aaron,
>
> I'm not sure if this will s
Hi Aaron,
I'm not sure if this will solve your quoting problems, but instead of rawdata()
you could trying using the encode() method to serialize a record object
for insertion into a database field. You can then use decode() to get the
record object back:
use MARC::File::USMARC;
# Serialize th
Hi All,
I am trying to clean up a raw MARC record for insertion in a MySQL
database. Here is my code:
$rec = $rec->rawdata();
$rec = $dbh->quote($rec);
I get the following error back:
DBD::mysql::st execute failed: You have an error in your SQL syntax.
Check the manual that corresponds to you
