Why does it think this is a field?
I think this is a .NET connector issue.
After creating all the connections I call the following:
IDbCommand.ExecuteNonQuery( "INSERT INTO WindwardPortal.Properties (`propName`, `propValue`) VALUES (`ImageNum`, 2)" );
And get the error:
MySql.Data.MySqlClient.MySqlException occurred
Message="#42S22Unknown column 'ImageNum' in 'field list'"
Source="MySql.Data"
ErrorCode=-2147467259
Number=1054
StackTrace:
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at WindwardRePortalSystemSetup.MySqlInfo.ExecuteStatement(IDbCommand cmd, String statement) in C:\src\RePortal\WindwardRePortalSystemSetup\MySqlInfo.cs:line 169
Subject
Written By
Posted
Why does it think this is a field?
December 01, 2006 06:24PM
December 02, 2006 09:54AM
December 03, 2006 12:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.