How to handle auto_increment with bindvalue()

Qjay

i have this simple table named Dependencies with following columns
depe_ID : INT AUTO_INCREMENT PRIMARY KEY
filename : varchar
revision_number : INT

i have this query to execute

 query.prepare("INSERT INTO Dependencies (depe_fileName,revision_number) "
                  "VALUES ( ? , ?)");


    
    query.bindValue(1,filename);
    query.bindValue(2, revision_number);

i get this error :

QSqlError("", "Parameter count mismatch", "")

SGaist

Hi,

At first sight your position parameter to bindValue are wrong. You have two values so it should be 0 and 1 not 1 and 2.

Planned maintenance has been done but it did not solve the problem. So work will continue on this and a new time for trying updates will be announced asap.

How to handle auto_increment with bindvalue()