Loading and saving an rtf file from mysql database

[Waqas.L.Khan]

Hi Guys,

I'm doing some work with richtextboxes and want to be able to save and
load the content from them to a mysql database (including all
formatting). I figured the best way to do this would be to save the
contant of the rtb to an rtf file and then load the file into a mysql
BLOB field:

Public Sub savetoDB()

Dim mysqldb As ADODB.Connection = New ADODB.Connection
mysqldb.Open(".......connection string....")
mysqldb.Execute("INSERT INTO table123 (content) VALUES
("LOAD_FILE('C:/test.rtf'))")
mysqldb.Close()

End Sub

The problem is that I don't know any way to extract the rtf from the
BLOB field and place it back into the file. I've tried looking into the
mysql forums but I'm not getting much help. Any help you can provide
would be appreciated.

Thanks,
Waqas

[Cor Ligthert [MVP]]

Wagaz,

In fact can you using this code do everything with any file that you want to
use as blob.

http://www.vb-tips.com/dbpages.aspx?...6-38b5a2f7fdf0

Have a look at the bottom, (as long as the pages are in reconstruction, this
for latter viewers of these pages)

Cor

<Wa**********@gmail.comschreef in bericht
news:11**********************@38g2000cwa.googlegro ups.com...

Hi Guys,

I'm doing some work with richtextboxes and want to be able to save and
load the content from them to a mysql database (including all
formatting). I figured the best way to do this would be to save the
contant of the rtb to an rtf file and then load the file into a mysql
BLOB field:

Public Sub savetoDB()

Dim mysqldb As ADODB.Connection = New ADODB.Connection
mysqldb.Open(".......connection string....")
mysqldb.Execute("INSERT INTO table123 (content) VALUES
("LOAD_FILE('C:/test.rtf'))")
mysqldb.Close()

End Sub

The problem is that I don't know any way to extract the rtf from the
BLOB field and place it back into the file. I've tried looking into the
mysql forums but I'm not getting much help. Any help you can provide
would be appreciated.

Thanks,
Waqas

[Waqas.L.Khan]

Many thanks Cor! That worked great!
Cor Ligthert [MVP] wrote:

Wagaz,

In fact can you using this code do everything with any file that you want to
use as blob.

http://www.vb-tips.com/dbpages.aspx?...6-38b5a2f7fdf0

Have a look at the bottom, (as long as the pages are in reconstruction, this
for latter viewers of these pages)

Cor

<Wa**********@gmail.comschreef in bericht
news:11**********************@38g2000cwa.googlegro ups.com...

Hi Guys,

I'm doing some work with richtextboxes and want to be able to save and
load the content from them to a mysql database (including all
formatting). I figured the best way to do this would be to save the
contant of the rtb to an rtf file and then load the file into a mysql
BLOB field:

Public Sub savetoDB()

Dim mysqldb As ADODB.Connection = New ADODB.Connection
mysqldb.Open(".......connection string....")
mysqldb.Execute("INSERT INTO table123 (content) VALUES
("LOAD_FILE('C:/test.rtf'))")
mysqldb.Close()

End Sub

The problem is that I don't know any way to extract the rtf from the
BLOB field and place it back into the file. I've tried looking into the
mysql forums but I'm not getting much help. Any help you can provide
would be appreciated.

Thanks,
Waqas