I have a query formulated as follows:
Qt Code: 
  1. insert into table (col1, col2, col3) values ("uniquething", :item1, :item2),("uniquething2", :item1, :item2),("uniquething3", :item1, :item2)
To copy to clipboard, switch view to plain text mode 

I use bindvalue as follows

Qt Code: 
  1. query.bindValue(":item1", "something");
  2. query.bindValue(":item2", "something2");
To copy to clipboard, switch view to plain text mode 

When the code executes the query, the result in the database is:

Qt Code: 
  1. col1         | col2      | col3 
  2. -----------------------------------------------------
  3. uniquething  | null      | null 
  4. uniquething2 | null      | null 
  5. uniquething3 | something | something2
To copy to clipboard, switch view to plain text mode 

so it seems that if there are multiple of the same placeholder, bindValue only replaces 1 of them, and leaves the others as null. Is this a bug or is it by design? and is there a way to bind a value to multiple placeholders, other than the obvious of naming all of them uniquely?