Sqlite Results

[Karoffe]

Well, i am working on a script actually just to learn more SQLITE, i used to use sqlite in the past but seems that now i forgot everything i learnt..

function onPlayerCommand() 
    local result = dbPoll(dbQuery( connection, "SELECT PlayerName FROM Test WHERE PlayerName=?;", 'test'), -1) 
    for i=1, #result do 
    outputChatBox(tostring(result[i].log)) 
    end 
end 
addCommandHandler ("result", onPlayerCommand) 

It outputs "Nil" instead of "Test".. I made a Sqlite Table which has 29 result in a table called PlayerName all the results should be "Test" but it outputs "nil" instead..

No Debug Errors.

[Karoffe]

Ops, Posted in the wrong board please anystaff move it to the right board

[Castillo]

That's because you are trying to obtain the "log" column data, but you are only selecting "PlayerName" in your query.

[Karoffe]

Sorry for late response.

That's because you are trying to obtain the "log" column data, but you are only selecting "PlayerName" in your query.

so i should remove ".log" in the outputchatbox right ?.. tried to do that but now instead of outputting "nil"

it outputs

table: 04B0AB58

table: 04B0ABD0

table: 04B0AC48

table: 04B0AC98

... and many more

[Sasu]

result.PlayerName

[xXMADEXx]

You can keep ".log" but change your query string to this:

SELECT * FROM Test WHERE PlayerName=?;