Re: Problem cleaning up MARC for MySQL

2006-01-01 Thread Saiful Amin
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

Re: Problem cleaning up MARC for MySQL

2006-01-01 Thread Mark Jordan
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

Problem cleaning up MARC for MySQL

2006-01-01 Thread Aaron Huber
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