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 application - ng. Could there be a problem with my ODBC driver? Here is its description: MySQL ODBC 3.51 Driver DSN. It is running on an old WinNT box with SP6a applied, and accessing a MySQL server running on a virtual RedHat v7.2 server. I have been able to do any selects I want ok. This is my first attempt to insert. >>> David Precious <[EMAIL PROTECTED]> 07/25/03 11:54 AM >>> On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should check? It's a syntax error. A quick Google (http://www.google.com/search?q=mysql+error+1064) would have found it for you. > The message text in my log started out with 'You have...'. > But, it was truncated and I could not see the rest. It would have been saying "You have an error in your SQL syntax near.... > It occurred on a > submitted insert statement originating in an application. The insert > statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]