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 & "CHRTRAN([" & request.form("txtNotes") & "], CHR(13) + CHR(10), [])," execstr = execstr & "[" & session("FullUserName") & "])'" response.write(execstr) oConn.EXECUTE(execstr)It doesn't work. Probably the SQL handler can't deal with the CHRTRAN function. And besides, I would want to preserve the CRLF in the saved text. I could maybe preclean the request.form("txtNotes") with a VB function before putting it into the execstr but still I would want to save the original format of the text.
>insert into mytable (memofield) values (CHRTRAN(memotext, CHR(13) + CHR(10), "")) >>>When using the SQL INSERT command, how do you "clean" a memo field if there are carriage returns in the memo text?