[Dr. Greg House]

Following database:

SQL_FastQuery(db, "CREATE TABLE IF NOT EXISTS Preferences (steamid TEXT PRIMARY KEY, lausch BOOLEAN, listen BOOLEAN);");

How can I fetch the result's values? Does SQL_FetchInt() return "0" or "1"? And if so, can I assign them to a bool directly, or do I have to parse them?

Thanks in advance!
House

[napalm00]

SQL_FetchInt is the one you have to use, it'll return 1 if the boolean is set to true, 0 if it's set to false.
If you really wanted to have the results as booleans (seems useless to me, but whatever) you could do

PHP Code:

new bool:bBool = SQL_FetchInt(dbhandle, slot); 


[Dr. McKay]

Yeah, SQL doesn't support booleans. Most of the time, for a boolean, a tinyint(1) field is used, containing 1 or 0. Therefore, there's no SQL_FetchBool.

napalm's suggestion ought to work, or you can just do if(SQL_FetchInt(....) == 1)

[necavi]

It does support BIT, if I remember correctly.