[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