Re: Problem cleaning up MARC for MySQL

2006-01-02 Thread bargioni
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

Re: Problem cleaning up MARC for MySQL

2006-01-02 Thread Dennis Boone
> 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

Re: Problem cleaning up MARC for MySQL

2006-01-02 Thread Edward Summers
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

Re: Problem cleaning up MARC for MySQL

2006-01-02 Thread bargioni
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.