Re: What are some common causes of syntax errors in queries?

[rodry]

It may be a problem with the way DBI handles the query. I swear the thing works fine until I start adding more fields to the loop that store the query's results

Anyways, I stayed up all night trying to figure it out. I even re-wrote the entire script. It worked fine until, as I mentioned, started adding more fields to that loop.

my $username = param("username");
my $password = param("password");
my $user2;
my $pass2;
my $name;
my $client;

&Create_DB_Connection;

$SQL = "SELECT name, clientid, login, password FROM Client WHERE login
+='$username' AND password='$password'";

&Do_SQL;

while ($pointer = $sth->fetchrow_hashref)
{
    $user2 = $pointer->{'Login'};
    $pass2 = $pointer->{'Password'};
    $name = $pointer->{'name'};
    $client = $pointer->{'ClientID'};
}

If I try to print out, say, $user2, it will give me a USE OF UNITIALIZED VARIABLE and it won't display the result. Therefore, I suspect the query is not executing for some odd reason. Also checked the case sensitivity of the tables heads. Please help.