Re: blob

[Jorge Bastos]

is there anyone alive?
nobody answers me.... (am i invisible?)


----- Original Message ----- 
From: "Jorge Bastos" <mysql.jorge@stripped>
To: <dotnet@stripped>
Sent: Thursday, December 23, 2004 10:11 AM
Subject: blob


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