note 50434 deleted from function.odbc-exec by googleguy

Note Submitter: Tom Cully <mail at tomcully dot com> ---- MS Access through ODBC doesn't just not like quotes (escape with '' - two single quotes), it also really hates newlines - chr(10)s - in LONGCHAR fields, and maybe in other BINARY based fields as well. Leave in a return character - chr(13) - to get a "new line" when working with LONGCHAR fields in ODBC/MS Access: Here's a function to do both for you: function odbc_access_escape_str($str) { $out=""; for($a=0; $a<strlen($str); $a++) { if($str[$a]=="'") { $out.="''"; } else if($str[$a]!=chr(10)) { $out.=$str[$a]; } } return $out; }