I am using VB.NET and tryign to get the followign SQL statement to work.
vSQL = "INSERT INTO ococ_Content (Text,PageID) VALUES ('" & Replace(FCKeditor1.Value, "'", "''") & "',1)"
I use the replace function b/c sometimes text contains words with tick marks ('). However, this does not work with FCKEditor. How is this normally handled? I tried taking out the Replace() entirely and that does not work either, so something is needed.
Thanks in advance!
vSQL = "INSERT INTO ococ_Content (Text,PageID) VALUES ('" & Replace(FCKeditor1.Value, "'", "''") & "',1)"
I use the replace function b/c sometimes text contains words with tick marks ('). However, this does not work with FCKEditor. How is this normally handled? I tried taking out the Replace() entirely and that does not work either, so something is needed.
Thanks in advance!