Hamilton, Kent [mailto:[EMAIL PROTECTED] wrote:
>
> Can not update UnprocessedMail. Error: You have an error in your SQL
> syntax. Check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'From = '[EMAIL PROTECTED]',
> MsgID = '<BB7A3D4475F89F4696DC
FROM is a reserved word in SQL. Personally, I recommend renaming the column
to something that won't cause this problem. Barring that you can put the
column name in double-quotes everywhere, e.g.:
INSERT INTO UnprocessedMail
("From", MsgID, ...)
Ronald
