[Qt-interest] mysql select query returns null

berkan kısaoğlu berkankisaoglu at gmail.com
Tue Aug 11 09:31:36 CEST 2009


hey all,
i need a fast reply, because i am at the deadline..

i have a code,

"
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");

db.setHostName(strlist[0]);

db.setDatabaseName(strlist[1]);

db.setUserName(strlist[2]);

db.setPassword(strlist[3]);

bool ok = db.open();


if(ok){

    QSqlDatabase defaultDB = QSqlDatabase::database();

    setupUi(this); // this sets up GUI

    QSqlQuery q;

    q.exec("SELECT gen_name,gen_id FROM project_general WHERE
gen_last='1'");

    QStringList strlist;

    strlist<<"";

    while(q.next()){ strlist<<q.value(1).toString()+ " / " +
q.value(0).toString(); }

"
but it query returns null.. (!)
but i can make insert operation, i have a connection that is established,

my question is why i can not execute select queries?

thanks in advice
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20090811/1cda0def/attachment.html 


More information about the Qt-interest-old mailing list