[nightscreem]

i don't get what this should do
i'm a complete noob at mysql

new Result:res = dbi_query(mysql, "SELECT * FROM config")

[Freecode]

* means everything
So it will SELECT EVERYTHING FROM config

[aragon]

Originally Posted by BAILOPAN Connections are killed at map change. dbi_close() will automatically reset the handle you made to -1 so you don't try to use it again.

How about connection lost due to other issues? Network problems, etc?
Will the handle obtainded from dbi_connect be changed, so I can detect this situation just by:

if(connection_handle < SQL_OK ) {
  // try to reconnect or exit
}

? If not, what is the proper way to do it? And is it possible to get info about the cause of the disconnection?

[BAILOPAN]

No, the handle will not be changed. If the connection suddenly dies, you will have to close and re-open it. You can check for a dead connection by seeing if a query died when it shouldn't (RESULT_FAILED).

[Eiver]

It seems that the DBI API cannot handle multiple result sets from stored procedures.
Executing queries like the one below will always fail:

dbi_query(dbhandle,"call MyStoredProc('Some input','Some more input')");

The query above works only if the stored procedure does not return anything. If it returns something, it will always fail.

I know that other APIs (like for example PHP and its mysql_query()) also had this problem. However in PHP it was possible to set client options, so that it would accept result sets from a stored procedure.

Is there a way to get around this problem in DBI API in AMX MOD X?

P.S
Since SQLX also has the same issue a new thread was created to deal with this problem in general.
The discussion is continued here http://forums.alliedmods.net/showthread.php?t=54852

[Podunk]

http://bugs.alliedmods.net/index.php...ls&task_id=281