Using queries from MySQL with newlines.

I'm working on an application that uses MySQL, and in one part the result from a query has newlines in it ("\r\n"). I have a edit control which I configured as multiline. when I use SetDlgItemText(hwnd, IDC_MYBOX, "text\r\ntext") it works, but SetDlgItemText(hwnd, IDC_MYBOX, row[0]).

Is there something I need to do?

1. I have never integrated MySQL with C/C++, and whole SetDlgItemText() function is unknown for me...

But I guess it would help us if you showed where you dumb the data in row[0] (I assume that's pointer to char array, right?). Perhaps you have some problem in there? Try couting/printing the contents of row[0] before using the function to see if it is what you expect.

Mmm.. Your nick makes me hope I could have helped more. I once knew one 'DarkLord' who helped me quite a lot

row[0] represents a MYSQL_ROW which is basically like a char. I think I need to run through the result and replace \r\n with char(13) and char(10). But is there an easy way to do this?