Problem with MySql query and JAVA
Posted on 2004-11-29
I have the following query
<!-- Delete a buddy from the roster -->
SELECT members.id delBuddy from members where Login = #buddyid#
SELECT members.id delBuddyFrom members where Login = #userid#
DELETE FROM memfavs
WHERE fav = #delBuddy
AND id = #delBuddyFrom
Which returns the following error...
java.sql.SQLException: Syntax error or access violation: You have an error
ur SQL syntax. Check the manual that corresponds to your MySQL server ver
or the right syntax to use near 'where Login = mimi
SELECT members.id delBuddyFrom where Log
I'm running a chat application and this is for users to remove buddies from their buddy list. If I do the query without specifying 2 conditions (and) it works fine, but as soon as I'm using more than one statement, it gives me this error...