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]