Updating with formatted SQL

<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br /><br />I run a small site with news posts that my members can add to, I am trying to implement an update feature, I have created a form which I populate with the news record required.<br /><br />But the text field that holds the news article needs to be able to contain any characters, how can I do this when I pull it from a <text area>?<br /><br />at the moment my SQL looks like this below (with the error I am getting) can you help?<br /><br />UPDATE newsfile SET newsid = '13', newstitle = 'Hello', newsbody = 'Lo everyone, Morg here. Soon as I find a chance to bug Mute a bit more, that piccy of the week should be changing (got a funny one of a pyro, lol). Btw, in case anyone is wondering, we don't have any more BWTFCL matches (bar the one this thursday) until early november - the reason for this is that alot of clans have dropped out of Div3, and just coincidentally, many of those dropouts were the clans we were schedueled to play in the near future. So hopefully Twinner will get us a couple of friendlies - there is one on the 26th for sure against Freakred's clan.', umail = 'pk1@iol.ie', uname = 'Morgoth', date = '31/10/2000 ',time = '5:13:56 PM' WHERE newstitle='Hello' <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Lo everyone, Morg here. Soon as I find a chance to bug Mute a bit more, that piccy of the week should be changing (got a funny one of a pyro, lol). Btw, in case anyone is wondering, we don't have any more BWTFCL matches (bar the one this thursday) until '. <br /><br />/updates/update2.asp, line 33 <br />

<i><b>Originally posted by : Despondent</b></i><br /><br />Simon,<br /><br />I just posted a similar question on the ASP board today under "despondent"....yes that's how I feel too. The funny thing is that the error does not occur for all records. The interesting thing is that after retrieving the record (that may cause the error) you can sometimes modify the text and the update will take place without any errors. Anyway, just thought I would mention my post in case no one responds to this one.<br /><br />Good luck!<br /><br />------------<br />Simon at 10/31/2000 11:23:42 AM<br /><br /><br />I run a small site with news posts that my members can add to, I am trying to implement an update feature, I have created a form which I populate with the news record required.<br /><br />But the text field that holds the news article needs to be able to contain any characters, how can I do this when I pull it from a <text area>?<br /><br />at the moment my SQL looks like this below (with the error I am getting) can you help?<br /><br />UPDATE newsfile SET newsid = '13', newstitle = 'Hello', newsbody = 'Lo everyone, Morg here. Soon as I find a chance to bug Mute a bit more, that piccy of the week should be changing (got a funny one of a pyro, lol). Btw, in case anyone is wondering, we don't have any more BWTFCL matches (bar the one this thursday) until early november - the reason for this is that alot of clans have dropped out of Div3, and just coincidentally, many of those dropouts were the clans we were schedueled to play in the near future. So hopefully Twinner will get us a couple of friendlies - there is one on the 26th for sure against Freakred's clan.', umail = 'pk1@iol.ie', uname = 'Morgoth', date = '31/10/2000 ',time = '5:13:56 PM' WHERE newstitle='Hello' <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Lo everyone, Morg here. Soon as I find a chance to bug Mute a bit more, that piccy of the week should be changing (got a funny one of a pyro, lol). Btw, in case anyone is wondering, we don't have any more BWTFCL matches (bar the one this thursday) until '. <br /><br />/updates/update2.asp, line 33 <br />