sqlite problem

[Castillo]

hi, i have a small problem and big at same time, this function keeps returning syntax error

function:

executeSQLDelete ( "PlayersEmail2","mail = '".. address .."'',subject = '".. selected .."'" ) 

error:

Database query failed: near "TEST": syntax error

TEST = subject

i hope someone can help me, thanks in advance.

[dzek (varez)]

executeSQLDelete ( "PlayersEmail2","mail = '".. address .."'[size=8][color=#FF0000]'[/color][/size],subject = '".. selected .."'" ) 

remove it

[Castillo]

it returns syntax error too:

Database query failed: near ",": syntax error

[Static-X]

executeSQLDelete ( "PlayersEmail2","mail = '".. address .."'","subject = '".. selected .."'" ) 

This should return no syntax errors

[Castillo]

true, there aren't any syntax error now but it deletes all rows from the table not only selected

[Aibo]

there could be only 1 condition string in executeSQLDelete, and you have to use "AND" in it, if you need multiple conditions to be met:

executeSQLDelete("PlayersEmail2","mail = '".. address .."' AND subject = '".. selected .."'") 

[Castillo]

thanks, its working now, i'm still a little noob on sqlite .

[greacius]

You can also use the query function... it looks lot like mysql in php or any other language.