How Do I Insert To A Memo Field???

<i><b>Originally posted by : Warren (tybeeware@aol.com)</b></i><br />In ASP, I try to insert to a memo field and always get a Syntaxt error. The same code works if I use a Text field to insert to but not for a memo. I have been trying to find the answer for a month now so if someone can help, I would appreciate it.<br /><br /><br />Desc1 = Request("Desc")<br />Set MYCONN = server.CreateObject("ADODB.connection")<br />Set RS = server.CreateObject("ADODB.recordset")<br />MYCONN.open "Tell"<br /><br />SQL1 = "INSERT INTO Email(Desc) VALUES(" & "'" & Desc1 & "')"<br /><br />response.write SQL1 <br /><br />RS.open SQL1, MYCONN<br />%><br /><br /><br />This works fine if I replace Desc1 with another text field name but Desc1 is a memo field and always gets a Syntax error.<br /><br />Thanks ahead for your help!<br /><br />Warren<br />tybeeware@aol.com

<i><b>Originally posted by : steve</b></i><br />what is your error?<br /><br /><br />------------<br />Warren at 4/17/2000 5:23:57 PM<br /><br />In ASP, I try to insert to a memo field and always get a Syntaxt error. The same code works if I use a Text field to insert to but not for a memo. I have been trying to find the answer for a month now so if someone can help, I would appreciate it.<br /><br /><br />Desc1 = Request("Desc")<br />Set MYCONN = server.CreateObject("ADODB.connection")<br />Set RS = server.CreateObject("ADODB.recordset")<br />MYCONN.open "Tell"<br /><br />SQL1 = "INSERT INTO Email(Desc) VALUES(" & "'" & Desc1 & "')"<br /><br />response.write SQL1 <br /><br />RS.open SQL1, MYCONN<br />%><br /><br /><br />This works fine if I replace Desc1 with another text field name but Desc1 is a memo field and always gets a Syntax error.<br /><br />Thanks ahead for your help!<br /><br />Warren<br />tybeeware@aol.com