Syntax error in SQL Statement?

<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br /><br />Can anyonr tell me what the problem is?<br /><br />UPDATE newsfile SET newsid = 9', newstitle = 'Council Members', newsbody = 'I will email you the password, can you all test this system and let me know of any bugs. Ta', umail = 'mute@mad.scientist.com', uname = 'Mute', date = '02/11/2000',time = '10:13:01 AM' WHERE newstitle=Council Members <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '9', newstitle = 'Council Members', newsbody = 'I will email you the password'. <br /><br />/updates/update2.asp, line 33<br />

<i><b>Originally posted by : Bill Bozeman (bill_bozeman@hotmail.com)</b></i><br />Looks like there is an apostrophe after the 9. Take that out and it should work, that is if newsid is an int. <br /><br /><br />------------<br />Simon at 11/2/2000 4:21:12 AM<br /><br /><br />Can anyonr tell me what the problem is?<br /><br />UPDATE newsfile SET newsid = 9', newstitle = 'Council Members', newsbody = 'I will email you the password, can you all test this system and let me know of any bugs. Ta', umail = 'mute@mad.scientist.com', uname = 'Mute', date = '02/11/2000',time = '10:13:01 AM' WHERE newstitle=Council Members <br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '9', newstitle = 'Council Members', newsbody = 'I will email you the password'. <br /><br />/updates/update2.asp, line 33<br />