QSqlQuery::bindValue problem

[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