sql error , need some help.

Tai

Member
the error.
Code:
14:36:41 Error in expression <E live.is_dead =0";
_result = _key call server_hiveReadWrite;

_status    = _res>
14:36:41   Error position: <server_hiveReadWrite;

_status    = _res>
14:36:41   Error Undefined variable in expression: server_hivereadwrite
14:36:41 File mpmissions\__cur_mp.chernarus\init.sqf, line 18

the sqf
Code:
 _key = "CHILD:999:UPDATE instance_deployable d LEFT JOIN (SELECT DISTINCT d.owner_id, s.unique_id FROM instance_deployable d LEFT JOIN survivor s ON s.id = d.owner_id WHERE s.is_dead =1 ) AS dead ON dead.owner_id = d.owner_id LEFT JOIN survivor live ON live.unique_id = dead.unique_id SET d.owner_id = live.id WHERE live.is_dead =0"; 
 _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 
	diag_log format["What pulled: Value of - _val : %1",_val]; 
 };
 
Back
Top