[Mono-list] [SOLVED] Re: Unknown column error when calling MySql stored procedure from Mono C#

[gewe]

Chris Howie-3 wrote:
> 
> I found it necessary for the connector to properly execute the stored
> procedure.  I had similar errors until I added the question mark.  Why
> this does not work doesn't make sense to me, but you might try using
> an @ prefix instead of the question mark, as this documentation seems
> to suggest:
> 
> <http://dev.mysql.com/doc/refman/5.0/en/connector-net-using-stored.html#connector-net-using-stored-calling>
> 
> -- 
> Chris Howie
> http://www.chrishowie.com
> http://en.wikipedia.org/wiki/User:Crazycomputers
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
> 
> 

Found it!
Use your question mark in the C# code, and remove the underscore from the
parameter name in both the C# code and the stored procedure.

Thanks for your help!
-- 
View this message in context: http://www.nabble.com/Unknown-column-error-when-calling-MySql-stored-procedure-from-Mono-C--tp19347812p19366751.html
Sent from the Mono - General mailing list archive at Nabble.com.