Variables in SQL statements

From: "suhail sarwar" <sarwar(at)postmaster(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Variables in SQL statements
Date: 2001-04-29 16:55:24
Message-ID: PM.3438.988563324@pmweb6.uk1.bibliotech.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Can I use a java variable in an SQL statement written in a java program?

I am trying to have user input for my java program which takes input variables from a user and inserts them into my postgresql database.

The problem is that at the moment I get an attribute not found error. Below is a snippit of the code:

...<<buffreredReader code here...>>...
String name = tKeyboard.readLine();
st.executeUpdate("INSERT INTO TEST13 " + "VALUES (name)");

The program compiles ok, but when run the program says attribute 'name' not found under SQL Exception.

Any help is much appreciated.

Kind Regards

Sarwar

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-04-30 03:58:50 Re: take my index, please
Previous Message suhail sarwar 2001-04-29 15:00:04 Multiple SQL statements in a java program for postgresql DB