Re: prepared statement
mamta81 wrote:
i [sic] am trying to insert data into a table using preparedStatement
Do you mean "PreparedStatement", as in java.sql.PreparedStatement?
Case matters in Java.
because i [sic] have to insert single quote(') in one of the
columns.Whenever i [sic] am a trying to insert a single quote it is not
working though in other columns new data gets inserted.
the query is
sqlQuery="insert into
po_item(po_no,po_item_cd,po_itemdesc,po_item_uom,po_item_unit_cost,po_item_qty,po_item_tax,po_item_dis,po_item_cost,SRL_NO)values
(?,?,?,?,?,?,?,?,?,?)";
desc po_item
Name Null
Type
------------------------------ --------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PO_NO NOT NULL
NUMBER(5)
PO_ITEM_CD NOT NULL
CHAR(12)
PO_ITEMDESC
What is all this?
Where is the code that tries to insert a single quote?
Could you maybe try formatting your Usenet posts to be actually readable, hmm?
PLS HELP!!!!!!!!!!!!!!!!!
Lay off the shouting, will you? It is annoying.
Provide an example that shows what you are doing and where it goes wrong, what
you expect to happen and what's happening instead. There isn't the
information in what you gave us to allow assistance.
What column are you trying to add a single-quote to? What data are you
feeding it?
FWIW, it's no problem to insert a single quote into any of the CHARACTER-based
column types using JDBC.
PreparedStatement ps = cxn.prepareStatement( sql );
ps.setString( 1, "'" );
--
Lew