El Sáb 28 Jun 2003 12:24, Zachary Perschall escribió: > Help! I'm trying to do an insert statement where one of the fields > sometimes contains an apostrophe. The field type is a varchar. Everytime > that one of these values comes up with an apostrophe, it tells me there is > an error in my SQL statement (obviously because it thinks there are more > information than there are fields I'm inserting into....) > > I'm sure this is something simple, but I can't seem to find the answer on > the web. Please help! > > -Zach
If you are programming in C, then you can use mysql_real_escape_string(). See the manual. Regards. -- Alfredo J. Cole http://www.acyc.com http://www.clshonduras.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]