Parameterized SQL commands
Posted by: David Dvali
Date: October 01, 2004 12:10PM

Hello.
I'm using NET Connector and want to instal some data to my table with parameterized SQL commands.
I wrote (C#):
============================
MySqlCommand mySqlCommand = new MySqlCommand("INSERT INTO table1 (userid) VALUES (@userid)", mySqlConnection);
mySqlCommand.Parameters.Add("@userid", "David");
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
============================
And after this it always inserts NULL value in userid field:(.
With textual data I can go without parameterized SQL, but how can I store binary data in BLOB fields?

Options: ReplyQuote


Subject
Written By
Posted
Parameterized SQL commands
October 01, 2004 12:10PM


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.