Using bound values in insert gives "parameter count mismatch" error in SQLite

[remy_david]

I had a similar problem leading to "parameter count mismatch" error.
I was trying to bind the table name like:

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

To copy to clipboard, switch view to plain text mode 

This is not possible, one can only bind filed values.
Could be useful for future readers.

[curtwagner1984]

I had a similar problem leading to "parameter count mismatch" error.
I was trying to bind the table name like:

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

QSqlQuery q;
q.prepare("SELECT * FROM :table");
q.bind(":table", "myTable");
q.exec();

To copy to clipboard, switch view to plain text mode 

This is not possible, one can only bind filed values.
Could be useful for future readers.

Your post helped my figure out what I was doing wrong with the same problem.
It's should be pointed out that it's also impossible to bind column names like so:

query.prepare("INSERT INTO Mytable (?,?) VALUES (?,?))"
query.addBindValue("columnOne");
query.addBindValue("columnTwo");
query.addBindValue("firstValue");
query.addBindValue("secondValue");

query.prepare("INSERT INTO Mytable (?,?) VALUES (?,?))"
query.addBindValue("columnOne");
query.addBindValue("columnTwo");
query.addBindValue("firstValue");
query.addBindValue("secondValue");

To copy to clipboard, switch view to plain text mode 

[d_stranz]

It should be pointed out that it's also impossible to bind column names like so:

That's why the method is named addBindValue(). It isn't a general purpose "substitute anything for anything" method, it is specifically for binding variable values to VALUES() placeholders in a query.

If you need to specify things like table and column names at run time, then construct the prepare() statement as a QString:

QString myTableName = "MyTable";
QString column1Name = "columnOne";
QString column2Name = "columnTwo";
QString queryStr = QString( "INSERT INTO %1 (%2,%3) VALUES (?,?);" ).arg( myTableName ).arg( column1Name ).arg( column2Name );
 
QSqlQuery query;
query.prepare( queryStr );
query.addBindValue( "firstValue" );
query.addBindValue( "secondValue" );
query.exec();

QString myTableName = "MyTable";
QString column1Name = "columnOne";
QString column2Name = "columnTwo";
QString queryStr = QString( "INSERT INTO %1 (%2,%3) VALUES (?,?);" ).arg( myTableName ).arg( column1Name ).arg( column2Name );

QSqlQuery query;
query.prepare( queryStr );
query.addBindValue( "firstValue" );
query.addBindValue( "secondValue" );
query.exec();

To copy to clipboard, switch view to plain text mode