hi everyone in this group, i am getting lately mysql syntax error when i run query
from JSP page. here is sample code:
public selectMyPass (String userid) {
String myQuery = "select pass from datainfo where id=";
myQuery.concate(myQuery,userid);
myResultSet = stmt.executeQuery(myQuery);
}
when i run that bean from JSP for mysql dataaccess, it gives Syntax error.
please help me out. thanks in advance.
PS. there not connection problem. i got hooked up with mysql server. i just leave
blank in my sample code.
---------------------------------
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
