Query binding always convert value to string and rely on sqlite3 implicit conversion. This will create problem with rtree tables.

[yuqian5]

Query binding always convert value to string and rely on sqlite3 implicit conversion. This will create problem with rtree tables.

[yuqian5]

Proposed solution 1

In query template, have multiple type of ?

?s - string
?i - int
?f - float
?d - double
?li - long int
?ld - long double

[yuqian5]

Proposed solution 2

Use boost::format