| 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: | Whole Thread | Raw Message | 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
| 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 |