Fwd: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Re: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I have managed to successfully run the following MySQL statement directly on the server hoasting MySQL: insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2', MealCount = '11'; And, I can view the table afterwards and see the record ok. when I run it from an applica