Can't use a variable for a column name?

Поиск
Список
Период
Сортировка
От Chris
Тема Can't use a variable for a column name?
Дата
Msg-id eac7b0710804241025k75e9aea3mef7f02c95c5a9c78@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can't use a variable for a column name?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Daniel Migowski
Дата:
Сообщение: Re: Expressiveness of SQLException
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Expressiveness of SQLException