<[email protected]> wrote in message news:[email protected] > I'm currently working with a framework which uses wstring, how can I > dynamically create queries like this: > std::wstring sQuery = L"SELECT * FROM Table WHERE Tilte = '"; > sQuery += title; //it's a wstring > sQuery += "'" > > I tried to use (const char*)sQuery.c_str() but it doesn't work.
Tried to use where? Doesn't work how? By the way, your approach is going to break if title happens to have apostrophes in it. Rather than building the statement like this, use parameterized queries. See http://sqlite.org/c3ref/prepare.html Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
