Why does it think this is a field?
Posted by: David Thielen
Date: December 01, 2006 06:24PM

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

Options: ReplyQuote


Subject
Written By
Posted
Why does it think this is a field?
December 01, 2006 06:24PM


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.