QSqlQuery::bindValue problem

[segfault]

hi

since the update to qt 4.5 i can't get QSqlQuery::bindValue to work
i tried google and searched the forum but couldn't find an answer to this question.

the following sample code works perfectly using qt 4.3.4, but with qt 4.5 i get this error:

QSqlError(-1, "QPSQL: Unable to create query", "ERROR: syntax error at or near "(" at character 10")

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QDebug>
#include <QVariant>
 
 
int main(int argc, char **argv) {
    QCoreApplication a(argc, argv);
    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("localhost");
    db.setDatabaseName("test");
    db.setUserName("testuser");
    db.setPassword("testpw");
    db.open();
 
    QSqlQuery q(db);
    q.prepare("SELECT :bla FROM myTable");
    q.bindValue(":bla","foo");
    if(q.exec()) {
        while(q.next()) {
            qDebug() << "output:" <<  q.value(0).toString();
        }
    }
    else {
        qDebug() << q.lastError();
    }
}

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QDebug>
#include <QVariant>


int main(int argc, char **argv) {
    QCoreApplication a(argc, argv);
    QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
    db.setHostName("localhost");
    db.setDatabaseName("test");
    db.setUserName("testuser");
    db.setPassword("testpw");
    db.open();

    QSqlQuery q(db);
    q.prepare("SELECT :bla FROM myTable");
    q.bindValue(":bla","foo");
    if(q.exec()) {
        while(q.next()) {
            qDebug() << "output:" <<  q.value(0).toString();
        }
    }
    else {
        qDebug() << q.lastError();
    }
}

To copy to clipboard, switch view to plain text mode 

if i do a

q.prepare("SELECT foo FROM myTable");

q.prepare("SELECT foo FROM myTable");

To copy to clipboard, switch view to plain text mode 

everything works just fine :/ but i can't get bindValue to work in qt 4.5
does anyone know what's the problem here?

[seneca]

Im not sure if this ought to work, since I always use value() method to get the selected columns.

If it shoud work at all, it might have to be bound as "out" or inout variable, the default is however QSql::in

In case your intention is to dynamically change column names of the query, maybe this is a solution:

query.prepare(QString("select %1 from mytable").arg("foo"));

[Lesiok]

if i do a

q.prepare("SELECT foo FROM myTable");

q.prepare("SELECT foo FROM myTable");

To copy to clipboard, switch view to plain text mode 

everything works just fine :/ but i can't get bindValue to work in qt 4.5
does anyone know what's the problem here?

But I think that after bindValue Your query looks like :

SELECT 'foo' FROM myTable

SELECT 'foo' FROM myTable

To copy to clipboard, switch view to plain text mode 

Try look at PostgreSQL logs.

[seneca]

That seems to be right.

Maybe the OP will make clear what he wants to achive.

[segfault]

But I think that after bindValue Your query looks like :

SELECT 'foo' FROM myTable

SELECT 'foo' FROM myTable

To copy to clipboard, switch view to plain text mode 

Try look at PostgreSQL logs.

SELECT 'foo' FROM myTable 
or
SELECT foo FROM myTable

SELECT 'foo' FROM myTable 
or
SELECT foo FROM myTable

To copy to clipboard, switch view to plain text mode 

doesn't matter, since they work both.


my problem is that i used

QSqlQuery q(db);
    q.prepare("SELECT :bla FROM test");
    q.bindValue(":bla",someVariable);

QSqlQuery q(db);
    q.prepare("SELECT :bla FROM test");
    q.bindValue(":bla",someVariable);

To copy to clipboard, switch view to plain text mode 

in a project using qt < 4.5 to create some select queries and it doesn't work in qt 4.5 anymore, it works fine for insert statements though.

but since a solution like

query.prepare(QString("select %1 from mytable").arg("foo"));

query.prepare(QString("select %1 from mytable").arg("foo"));

To copy to clipboard, switch view to plain text mode 

works fine, i will use this. (should have done it like that in the first place)

thanks everybody for your help.

[seneca]

SELECT 'foo' FROM myTable 
or
SELECT foo FROM myTable

SELECT 'foo' FROM myTable 
or
SELECT foo FROM myTable

To copy to clipboard, switch view to plain text mode 

doesn't matter, since they work both.

Yes they both work, but they do different things of course.

The first will always return the text foo, no matter what is actually in the table, and the second will return the content of the column with name foo.

[segfault]

Yes they both work, but they do different things of course.

The first will always return the text foo, no matter what is actually in the table, and the second will return the content of the column with name foo.

i know sorry, i just wanted to point out that i would be happy with either of them, instead of the error i got