INSERT query !!

Поиск
Список
Период
Сортировка
От Atika
Тема INSERT query !!
Дата
Msg-id Pine.OSF.4.03.9902172054200.6790-100000@seralph15.essex.ac.uk
обсуждение исходный текст
Список pgsql-sql
HI!!
I am hoping someone can help me with a problem I have.

I am trying to insert values in my pgsql database through a Java
application.
The problem is that I need to insert a String into a table.  But, as I am
not going to know the value of this String before hand I can't really put
a value within two single qoutes.
I am basically trying to do something like this:

String input = "This is a String";

myConn.updateQuery("insert into myDB values(input)");

but get an error when I  run it saying:
ERROR:  attribute input not found
java.sql.SQLException: ERROR:  attribute input not found

I am also going to have to insert intger and other such vlaues but am not
going to know their values in the insert statement.

many thanks for your time and help.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Atika
Дата:
Сообщение: ...
Следующее
От: Atika
Дата:
Сообщение: INSERT query (using insert from a Java application, concerning String input)