I don't see any ticks surrounding userid...unless of coarse userid is a
number??
Also, myResultSet, is that public? If not, are you returning it? (I'm not
familiar with Java, so not sure if you need to or not)
----- Original Message -----
From: "Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 12:17 PM
Subject: Syntax error
>
> 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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php