Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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

( #7828=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > What are some common causes of syntax errors in queries? contributed by 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.

Comment on Answer: What are some common causes of syntax errors in queries?
Select or Download Code
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (5)
As of 2015-07-30 02:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls