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
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 |