Castillo Posted November 11, 2010 Posted November 11, 2010 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. San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
dzek (varez) Posted November 11, 2010 Posted November 11, 2010 executeSQLDelete ( "PlayersEmail2","mail = '".. address .."'[size=8][color=#FF0000]'[/color][/size],subject = '".. selected .."'" ) remove it Multi theft auto tools - replace cars and peds, move your map or compile your Lua files online! programista php rzeszów Need free webhosting for your small site? PM me. Need help with portforwarding? PM me. Do not PM me asking for help with scripting. Having problems with port forwarding? Send me pm, I can do whole thing for you using TeamViewer (already helped about 20 people, no worries)!
Castillo Posted November 11, 2010 Author Posted November 11, 2010 it returns syntax error too: Database query failed: near ",": syntax error San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
Static-X Posted November 11, 2010 Posted November 11, 2010 executeSQLDelete ( "PlayersEmail2","mail = '".. address .."'","subject = '".. selected .."'" ) This should return no syntax errors
Castillo Posted November 12, 2010 Author Posted November 12, 2010 true, there aren't any syntax error now but it deletes all rows from the table not only selected San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
Aibo Posted November 12, 2010 Posted November 12, 2010 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 Posted November 12, 2010 Author Posted November 12, 2010 thanks, its working now, i'm still a little noob on sqlite . San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
greacius Posted November 18, 2010 Posted November 18, 2010 You can also use the query function... it looks lot like mysql in php or any other language. http://AllesOverServers.nl http://www.zakelijkthuis.nl/promoot.php?x=4179
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now