Variables not working

[CodeNeos]

Why is my function not working correctly?

int AuthSocket::CountChar(uint8 account, uint8 realm)
{
	std::stringstream query;
	query << "SELECT count(*) AS `count` FROM `characters` WHERE `acct`='" << account << "' AND `realm`='" << realm << "'";
	QueryResult *result = sDatabase.Query( query.str().c_str() );

	if(result)
	{
        Field *fields = result->Fetch();
		int numchars = fields[0].GetUInt8();
		return numchars;
    }
	else
	{
		return 0;
	}

}

instead of running sql query "SELECT count(*) AS `count` FROM `characters` WHERE `acct`='2' AND `realm`='3' ";
It runs the query with smilys instead of nummers (input CountChar(2,3) )??

[olivthill]

If you see smileys instead of numbers, that's because numbers should be converted to strings.
An SQL statement is a long string containing only Ascii characters, not binary numbers

[Naumaan]

"SELECT count(*) AS `count` FROM `characters` 
WHERE ` acct `= ' " << account <<  " ' AND `realm`= ' " << realm << " ' ";

As i understand why u r passing ur acct and realm values as char type remove single quote as highlight above as red and then try it.

[CodeNeos]

Using ' or no ' makes no difference.

I also tough the same thing about converting the int to char but i don't have a clue how to do that.

something like:

std::stringstream acc;
acc << account;

[Philip Nicoletti]

If I understand your problem correctly, you can cast the char
variables (unit8) to int variables ...

    query << "SELECT count(*) AS `count` FROM `characters` WHERE `acct`='" 
          << static_cast<int>(account) << "' AND `realm`='" 
          << static_cast<int>(realm) << "'";

[CodeNeos]

If I understand your problem correctly, you can cast the char
variables (unit8) to int variables ...

    query << "SELECT count(*) AS `count` FROM `characters` WHERE `acct`='" 
          << static_cast<int>(account) << "' AND `realm`='" 
          << static_cast<int>(realm) << "'";

thanks it works correctly now. I will keep this in mind for the next time i ecounter such a problem.