From: | Peter Garner <peter_garner(at)yahoo(dot)com> |
---|---|
To: | Atika <agoswa(at)essex(dot)ac(dot)uk>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] INSERT query (using insert from a Java application, concerning String input) |
Date: | 1999-02-18 00:46:14 |
Message-ID: | 19990218004614.5114.rocketmail@send205.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
Hi Atika! :-)
> 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
Try
String input = "This is a String"
String query = insert into myDB value ('" + input + "')"
myConn.updateQuery(query);
==
Peace,
Peter
We are Microsoft of Borg, you will be assimilated!!!
Resistance is fut... ***BZZZRT*** THUD!!!
[General Protection Fault in MSBorg32.DLL]
Please contact the vendor for more information
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Haberlach | 1999-02-18 02:54:42 | List of characters to escape for safe psql imports |
Previous Message | Chr. Burmester | 1999-02-17 22:31:29 | (no subject) |
From | Date | Subject | |
---|---|---|---|
Next Message | David Martinez Cuevas | 1999-02-18 00:52:19 | Re: [SQL] Question about SQL FUnction |
Previous Message | Brett W. McCoy | 1999-02-18 00:22:59 | Re: [SQL] INSERT query (using insert from a Java application, concerning String input) |