4 messages in com.mysql.lists.dotnetblob
FromSent OnAttachments
Jorge Bastos23 Dec 2004 02:11 
Jorge Bastos23 Dec 2004 06:10 
Jorge Bastos23 Dec 2004 06:28 
Reggie Burnett27 Dec 2004 08:01 
Subject:blob
From:Jorge Bastos (mysq@decimal.pt)
Date:12/23/2004 02:11:18 AM
List:com.mysql.lists.dotnet

DecimalHi Reggie,

I have a little problem, when using the old 0.76 when i insert values in a blob
field it was ok, now when i changed to 1.0.3 isn't working. Perhaps the code need something to be ajusted? I'll show below how i was inserting the images into the blob field. The field gets empty with 1.0.3! Can you give me a tip?

The code:

MyCon = New MySqlConnection("cs here")

MyCon.Open()

MyCmd = New MySqlCommand(sql, MyCon)

sql = "insert into imagens values ('" + txtemp.Text + "','" + lg + "',@buffer)"

MyCmd.CommandText = sql

MyCmd.Connection = MyCon

MyCmd.Parameters.Add(New MySqlParameter("@buffer", buffer))

MyCmd.ExecuteNonQuery()

mycon.close