QSqlQuery how to get value of a count?

Question

I have a query that is just getting the count of table based on some criteria eg:

QSqlQuery query("SELECT COUNT(*) FROM some_table WHERE some_value = :something");
query.bindValue(":something", "something");

my question is how do i get result of this back, obviously this is where you would use

query.value(int);
query.value(QString);

But the docs say that int index one shouldnt be used because we dont know what the index would be andi cant use the string one because there is no filed to define as the one i want the result for. so assuming i am correct in saying that how is it that i can get the count integer value into a int variable from this query

cheers

borisbn · Accepted Answer · 2014-09-25 12:46:43Z

6

Make an alias to field count. Like this:

QSqlQuery query("SELECT COUNT(*) CNT FROM some_table WHERE some_value = :something");

and then query by name CNT

answered Sep 25, 2014 at 12:46

borisbn

5,07429 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

AngryDuck Over a year ago

When doing that i get QSqlQuery::value: not positioned on a valid record

borisbn Over a year ago

Did you call query.exec() and query.first()

AngryDuck Over a year ago

executed the query yea, but didnt put first, will try it now

AngryDuck Over a year ago

Thank you :), having read that first() will position itself on the first valid record that makes perfect sense cheers

AngryDuck Over a year ago

will probably change that variable name though dont want to typo that!

Hasan · Accepted Answer · 2018-02-14 21:45:45Z

0

You can also use: Query.next(); Query.value(0).toInt();

For this msg: QSqlQuery::value: not positioned on a valid record you should do: Query.next(); to change the pointer to first record!

answered Feb 14, 2018 at 21:45

Hasan

413 bronze badges

Collectives™ on Stack Overflow

QSqlQuery how to get value of a count?

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related