How to work if db.query, example, if that return a empty value?

[jonathan.dsa]

Hello, i have made a script for find in a table if this guild already registred or not, but return that error: '[Result:getDataString] Result not set!', where is the problem on my script? :

        guild = getPlayerGuildId(cid)
	chck = db.getResult("SELECT `guild_id` FROM `rookwar.guild` WHERE `guild_id` = '"..guild.."' LIMIT 1;")
	if (chck:getID() ~= -1) then
		chcar = check:getDataString('guild_id')
		chck:free()
	end
	if guild ~= chcar then
		db.executeQuery("INSERT INTO `rookwar` (`player`) VALUES ('" ..nome.. "');")
	end

- - - Updated - - -

the error is on that line:

chcar = check:getDataString('guild_id')

- - - Updated - - -

how work if empty result?

 

[v0id408]

chcar = chck:getDataString('guild_id');

test this ^

 

[jonathan.dsa]

[Result:getDataString] Result not set! - still with problem =/

- - - Updated - - -

can close, solved