Database query

[Drakath]

I get this error: Database query failed: no such column: Drakath

  
local sql = { Query = executeSQLQuery }; 
sql.Query( "INSERT INTO myTable ( name, ID, city ) VALUES ( "..getAccountName(getPlayerAccount(source))..", "..ID..", "..city.." )" ); 

How come it recognizes a value as a column?

[Walid]

are you sure that there is a column with that name (Drakath).

[Drakath]

There is no such column. "Drakath" is supposed to be the value and "name" is the column.

[Walid]

There is no such column. "Drakath" is supposed to be the value and "name" is the column.

add table

executeSQLQuery("CREATE TABLE IF NOT EXISTS myTable (name TEXT, ID TINYTEXT, city TEXT)") 

executeSQLQuery( "INSERT INTO myTable (name,ID,city ) VALUES (?,?,?) ",getAccountName(getPlayerAccount(source)),ID,city) 

[Drakath]

Thanks.

[Walid]

Thanks.

np.