JDBC problem with DELETE

From: Dnesbitt(at)encryptix(dot)com
To: pgsql-interfaces(at)postgresql(dot)org
Cc: Dnesbitt(at)encryptix(dot)com
Subject: JDBC problem with DELETE
Date: 2000-07-27 04:41:26
Message-ID: 19016070071ED411B61300508BAC4B750418BC@EXCH1ETIX
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

The following piece of code:

stmt.executeUpdate("delete from friend where name='"+someName+"'");

is returning:

SQLException: java.sql.SQLException: ERROR: Attribute 'John Doe' not
found

where someName is "John Doe".

Any ideas? The row where name='John Doe' is definitely in the table and I
can execute the statement without problems from psql.

Thanks in advance for your help.

Regards,
//Dave

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message S.A.Pamungkas 2000-07-27 05:37:20 result not appear
Previous Message Joel Burton 2000-07-26 18:36:42 Access + Microsoft Access FAQ (Long)