Get data from DB

[Notsapl]

Hi, can u help me ?

I have some problem with get any data from db , this is my example code : 

    _key = format["CHILD:999:select `value` from `notsa_addon_data` where `addon` = 'communication' and `key`='last_id' LIMIT 1:[]:"];
	//_data = "HiveEXT" callExtension _key;              
	//_result = call compile _data;
	_result = _key call server_hiveReadWrite;
	_status    = _result select 0;            // get the status of the result
	if (_status == "CustomStreamStart") then {    //check if the stream coming from the hive was opened
		_val = _result select 1;                  // get the number of entries that will be coming in the stream
		if(_val > 0) then {
			_result = _key call server_hiveReadWrite;
			_bankingstart = _result select 0;
		};
	};
    _notsacommunication_last_id = _bankingstart;

	diag_log("[NotsaAddon Communication] Load last key : "+str(_notsacommunication_last_id) );


	_key = format["CHILD:999:select `message`,`author`,`id` from `notsa_communication_msg` where `id` > %1  LIMIT 1:[]:",_notsacommunication_last_id];
	_result = _key call server_hiveReadWrite;

 

Why second query is  : " select `message`,`author`,`id` from `notsa_communication_msg` where `id` >   " when in log i can read:

[Information] Result : ["CustomStreamStart",1]

[Information] Result : [5] <-- Here is true data from db : last_id = 5

Why in second query variable _notsacommunication_last_id is empty ?

 

Thanks for any help ! :)

[Notsapl]

Reason:

Uninitialized variable