mtangoo / wxDatabase

wxWidgets library for connecting to major relational database
http://mtangoo.github.io/database/index.html
36 stars 16 forks source link

SQLite3 WHERE with Like does not work #20

Closed mtangoo closed 4 years ago

mtangoo commented 8 years ago

Investigate this as it does not work. sqlite3_bind_parameter_count returns always zero

mtangoo commented 4 years ago

Like works fine

wxString likeParam;
likeParam.Printf("%%%s%%", searchText);
wxPreparedStatement *stmt = database->PrepareStatement("SELECT * FROM users WHERE name LIKE ?  ASC LIMIT ?;");
stmt->SetParamString(1, likeParam);
stmt->SetParamInt(3, m_resultsLimit);