SQLite Extraction Error [SOLVED]

[hahaha]

code just like bellow:

Code: Select all

std::string aName;
std::string match("Peter");
ses << "SELECT NAME FROM FORENAME WHERE NAME=:name", into(aName), use(match), now;
poco_assert (aName == match);

will throw a Extraction Error exception.

but this

Code: Select all

Poco::Uint32 count;
std::string match("Peter");
ses << "SELECT count(*) FROM FORENAME WHERE NAME=:name", into(count), use(match), now;


will run successfully,why?

[alex]

code just like bellow:

Code: Select all

std::string aName;
std::string match("Peter");
ses << "SELECT NAME FROM FORENAME WHERE NAME=:name", into(aName), use(match), now;
poco_assert (aName == match);

will throw a Extraction Error exception.

How many rows does the first query return? If it's more than one, there is no room for al the return values in the supplied storage, thus exception.
Try

Code: Select all

std::vector<std::string> aName

.

[hahaha]

It works,thank you!