Can't use a variable for a column name? - Mailing list pgsql-jdbc

From Chris
Subject Can't use a variable for a column name?
Date
Msg-id eac7b0710804241025k75e9aea3mef7f02c95c5a9c78@mail.gmail.com
Whole thread Raw
Responses Re: Can't use a variable for a column name?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-jdbc
A user enters a name into a textfield and clicks on a "Find" button.  Depending on which text field the user entered the data, the appropriate column name in the table is used for fieldName and the entered text is passName.  However, the fieldName doesn't return anything.  But if I replace fieldName with the column name ("WHERE first_name='"), the program returns values.  Can't we use variables for column names or do I have to just put it all in an if/else statement?

Here is my code:

              result = fe.executeQuery("SELECT first_name, last_name, emp_nbr, emp_type_code, emp_status_code, emp_work_center " +
                                            "FROM employee " +
                                            "WHERE '"+fieldName+"'='"+passName+"'");

pgsql-jdbc by date:

Previous
From: Daniel Migowski
Date:
Subject: Re: Expressiveness of SQLException
Next
From: Oliver Jowett
Date:
Subject: Re: Expressiveness of SQLException