MySQL - Returning a value in a record

[ksqt]

I cannot seem to return text from a record in a table..
In this function - "bg_word" is a text string in a record in a table.
I can return an integer if I make the necessary changes, but not text...
What am I missing?
(Yes, there is warnings of not using the two bools - not important at this point)

void Dialog::translate()
{
	QString bg;
	QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("");
	db.setDatabaseName("enbg_database");
	db.setUserName("");
	db.setPassword("");
	bool ok = db.open();
 
	QSqlQuery query;
	bool queryok = query.exec("select bg_word from enbg_table where id=1");
	while(query.next())
	{
		bg = query.value(0).toString();
	}
 
	translated_bg->setText(bg);
}

void Dialog::translate()
{
	QString bg;
	QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
	db.setHostName("");
	db.setDatabaseName("enbg_database");
	db.setUserName("");
	db.setPassword("");
	bool ok = db.open();

	QSqlQuery query;
	bool queryok = query.exec("select bg_word from enbg_table where id=1");
	while(query.next())
	{
		bg = query.value(0).toString();
	}
	
	translated_bg->setText(bg);
}

To copy to clipboard, switch view to plain text mode 

[ksqt]

Any ideas why the string is returning (I think) null or empty?
Sorry for the bump, but I can't seem to figure this one out.

[sunil.thaha]

Is bg_word a field or data ?
Query seems to be fine.

Whatis the return value for the open()

[ksqt]

bg_word is a field in the table.
If I change the query, I can have an integer show, so open() is "working".....

[sunil.thaha]

Try printing bg inside while() ...

Also what is the datatype of bg_word in mysql is it varchar ...

and Ya. Try printing the type of QVariant

[ksqt]

That doesn't work....
and it is varchar...

[sunil.thaha]

Again.

Did to put a debug inside while and see what is you are getting.
And what is the type of the QVariant ?

May be the query returns 2 values and the old bg may be getting overwritten

what was the output of the debug