SQL Problem

[FWCentral]

There is an error here in the debug script : Database query failed: No such column: false

Attempt to the length of local 'gname' (a boolean value)

The database "Government_members" exists and so does "govName"

  
local nam = getAccountName(getPlayerAccount(player)) 
local gname = executeSQLQuery("SELECT govName FROM Government_members WHERE name = ?", nam) 
if #gname >= 1 then 
  

[DiSaMe]

Government_members is a database? AFAIK, it should be a table.

[FWCentral]

Sorry yes it's a table and the "govName" is a field but that's not the problem as far as i know.

[DiSaMe]

Maybe the error is about column called 'name' which you wrote after WHERE?

[FWCentral]

But the data is in the name field i can't see any problem

[DiSaMe]

I tested it and I see where's the problem now. You didn't put the quotes where the name gets inserted. So this should work:

local gname = executeSQLQuery("SELECT govName FROM Government_members WHERE name = '?'", nam) 

[StifflersMom]

If this is the problem, the wiki for executeSQLQuery should be updated

local result = executeSQLQuery("SELECT money FROM players WHERE name=?", playerName) 

May be, the space between = and ? is also a problem

[DiSaMe]

It's not. I was learning to script in SQL yesterday and today and it works with spaces too.

[StifflersMom]

Then the wiki part is wrong. If you see it in "pure" sql, then you can do a

"SELECT whatever FROM table where whatever = 1" This is correct for a numerical value.

For Chars, Varchars or Text it should be "SELECT whatever from table where whatever = '1' "

[FWCentral]

Well this is what i use for my spawn system and it works fine;

  
            local teams = executeSQLQuery("SELECT team FROM Spawn WHERE name = ? AND city = ?",tostring(spawn), tostring( location )) 
  

Ill test the one you put Crystal and get back.

[DiSaMe]

Oh, if that works fine, that means the function puts the quotes automatically. But the problem in your script probably comes from getAccountName return value. From the error you wrote, it seems to return false, so the quotes aren't put around it, unlike strings. You need to check what it returns before executing the query.

[FWCentral]

Yes you are right Crystal its not the database error its the nam,

  
function onLogin(source) -- using it like this onPlayerLogin was the problem.