insert into mytable (memofield) values (memotext)I am running this from an ASP page and it crashes if there are CRLF in the memotext.
execstr = "EXEC 'insert into memos (link_table,record_id,memo_name,memo_text,added_by)" execstr = execstr & " values ([people]," execstr = execstr & lcPerson_id & "," execstr = execstr & "[notes]," execstr = execstr & "[" & request.form("txtNotes") & "]," execstr = execstr & "[" & session("FullUserName") & "])'" response.write(execstr) oConn.EXECUTE(execstr)Thanks