How to check if SQL request returned empty result

[bubnenkoff]

string query_string = (`SELECT user, password FROM otest.myusers where user LIKE ` ~ `'%` ~ request["username"].to!string ~ `%';`);
        auto rs = db.stmt.executeQuery(query_string);

        string dbpassword;
        string dbuser;

        while (rs.next())
        {
            dbuser = rs.getString(1);
            dbpassword = rs.getString(2);
            writeln(dbuser);
            writeln("Place unreachable"); // if SQL result is empty

How I can check if SQL request returned empty result?

[buggins]

Btw, there might be sql injection. E.g. if username entered is ' or user LIKE ' all users will be returned. Use quoting of string before appending to query.