PostgreSQL prepared statement failure

[John Blunket]

Hi,
I have a prepared statement in my java code:

        String updateMediaQuery = "UPDATE media SET id_project=$,type=$,name=$,importDate=$," +
                "comment=$ WHERE id_media=$";

        PreparedStatement ps;
        
            ps = conn.prepareStatement(updateMediaQuery);
            ps.setInt(1, media.getIdProject());
            ps.setInt(2, media.getIdType());
            ps.setString(3, media.getMediaName());
            ps.setString(4, media.getCreateDate());
            ps.setString(5, media.getComment());
            ps.setInt(6, media.getIdMedia());

            ps.executeUpdate();

    

When I execute it, it throws an exception:
org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.

Whats happening?

John.

[Jan Cumps]

The placeholder is '?', not '$'.

[John Blunket]

Jan,
Thanks, what a fool I am!!

John.

[Paul Sturrock]

David Blunket, please check your private messages.