Sql

[piertiong]

what's wrong?

String s = "SELECT * from login WHERE id = '"+ userId + "' AND password = '" + userPw + "'";

[Nedals]

If this is mySQL for Perl, then...

my $s = "SELECT * FROM login WHERE id = '$userId' AND password = '$userPw'";
where..
my is used in a strict enviroment (left out if not using strict.)
$s is a string variable (use $sql or $query instead, it's easier to debug later)
'login' is the name of the table (NOT a variable)
$userId and $userPW are variables.

Does that help?

[piertiong]

Originally posted by nedals
If this is mySQL for Perl, then...

my $s = "SELECT * FROM login WHERE id = '$userId' AND password = '$userPw'";
where..
my is used in a strict enviroment (left out if not using strict.)
$s is a string variable (use $sql or $query instead, it's easier to debug later)
'login' is the name of the table (NOT a variable)
$userId and $userPW are variables.

Does that help?

sorry i am using it for jsp. thanks anyway for your reply!