SQL Problem

[mjau]

ok i got a problem when trying to get a vlue from db, and show it in label.

SQL function

function getBankMoney(acccountName) 
    local money = executeSQLSelect("players", "bankMoney", "accName = '"..accountName.."'") 
    return money[1]['bankMoney'] 
end 

Clientside functions in the script calling export

function updateMoney(balance) 
guiSetText (GUIEditor.label[1], "Current Balance: "..balance) 
end 
addEvent("updateMoney", true) 
addEventHandler("updateMoney", localPlayer, updateMoney) 
  
function getMoney() 
triggerServerEvent ( "getMoney", getLocalPlayer())  
end 

serverside function in the script calling the export

function getMoney() 
    local account = getPlayerAccount(source) 
    local accountName = getAccountName(account) 
    money = exports["SQL"]:getBankMoney(accountName) 
    triggerClientEvent ("updateMoney", source, money) 
end 
addEvent("getMoney", true) 
addEventHandler("getMoney", getRootElement(), getMoney) 

and now the error:

[2013-01-19 22:44:32] ERROR: [RLR]\SQL\main_S.lua:33: attempt to concatenate global 'accountName' (a nil value)

[2013-01-19 22:44:32] ERROR: call: failed to call 'SQL:getBankMoney' [string "?"]

[Castillo]

Seems like "accountName" is returning nil at getBankMoney.

[mjau]

which means that it didnt get the account ?, but how is that possible, the player is the source...

[Castillo]

Try this and see what it outputs:

function getBankMoney ( acccountName ) 
    if ( accountName ) then 
        local money = executeSQLSelect ( "players", "bankMoney", "accName = '".. accountName .."'" ) 
        return money [ 1 ] [ 'bankMoney' ] 
    else 
        outputChatBox ( "No account name" ) 
    end 
end 

[mjau]

It outputs "No Account Name"

[Sarrum]

kimmis9, change 'acccountName' on 'accountName' in function arguments.

[mjau]

Ahh tnx, another typo lol. the sql script is something i never finished and started to use now. anyways ty