Using QSqlQuery bindValue()

Home
Forums
Qt Development
General and Desktop
Using QSqlQuery bindValue()

July 10, 2010

joseph.s

Lab Rat
1 posts

Hi,

I’ve just started using Qt 4.6. I have the following code:

User *UserMapper::getByUsername(QString username)
{
// Get user from database.
QString sql = "select username, password from users "
"where username = :username";
QSqlQuery query;
if (false == query.prepare(sql)) {
qDebug("Failed to prepare query.");
return 0;
}
query.bindValue("username", username);
...
}

However, it does not compile:

error C2664: ‘void QSqlQuery::bindValue(const QString &,const QVariant &,QSql::ParamType)’ : cannot convert parameter 2 from ‘QString’ to ‘const QVariant &’

I must be missing something very obvious. Do I have to manually convert the QString to QVariant? How do I do that?

Thanks!

3 replies

July 10, 2010

Tobias Hunger

Mad Scientist
3125 posts

Have you tried using “QVariant(username)” instead of using “username” directly? The conversion should actually happen implicitly… maybe you forgot to include the QVariant header?

July 10, 2010

Andre

Area 51 Engineer
6031 posts

Also, I think that you should do:

query.bindValue(":username", username);

That is, include the colon in the binding code.

Signature

Looking for Qt developers to join our team @ i-Optics: https://qt-project.org/forums/viewthread/25393/

July 10, 2010

joseph.s

Lab Rat
1 posts

Thank you very much for the help! You are both correct. I actually did forget to include the QVariant header, and it is supposed to be “:username” instead of “username”.

‹‹ Undefined DESTDIR_TARGET and other variables in Mac OSX How can I style a QToolBar extension button icon via CSS ››

You must log in to post a reply. Not a member yet? Register here!

Tags what is this? Undo?

Ratings what is this?

Forum menu

Not registered?

July 10, 2010