On October 22, 2004 at 10:56, Steve wrote: > I'm using mhonarc to archive a listserv, and I'd like to provide a small > amount of search functionality by subject/author name/date. To do this, > I've made a resource file that basically creates a mysql script with > message file name, date, author "name", author email, and subject, which > I can then access via a LAMP setup. However, I'm having problems with > the author name portion. Some people have single quotes in their email > client settings, which of course breaks the mysql "insert into..." command.
An alternative is to have the resource file create a file which is then read to generate the mysql script. I.e. Why create the mysql script directly? Create a file that is read by a script that invokes/creates the proper mysql calls. This way, you have complete control over how the data is escaped or pre-processed before put into mysql. --ewh
