MFC - Getting BLOB from MySQL Field

[Austin Harvey]

Hi

I have a simple task to transfer data from multiple tables in a MySql database into a single table.

I am using MFC for the task (simply because I haven't programmed in C# or C++ for about 5 years Frown | :( )

I need to jog my memory on Variable and strings etc so could someone help me with the following question.

I am using CRecordSet -> GetFieldValue(). Now this is fine for my text fields etc, but when it comes to a BLOB, or MEDIUMTEXT I'm struggling with an error.

CString sProdName;
sections.Open(CRecordset::snapshot,SqlString);
sections.GetFieldValue(_T("Section text"),sProdName);

Should I be creating another type of variable to read this information in ? I don't need to do anything with it apart from write it straight back out.

Thanks.
Austin.