Posted By:
pavan_sharma
Posted On:
Tuesday, January 9, 2007 02:34 AM
I have this code for example.......... sqlstmt = "UPDATE CATEGORIES SET SUB=? , HAS_SUB=? WHERE ID=?"; pstmt = conn.prepareStatement(sqlstmt); pstmt.setString(1,subcatids); pstmt.setString(2,"Y"); pstmt.setString(3,selsubcat); pstmt.executeUpdate(); There is no problem in code...and query updated successfully... but here i want to print the 'sqlstmt' statement....to know what exactly query contain in place of palce holder (?)... how can print it with preparedstatement.... Reply me ASAP Thanks
More>>
I have this code for example..........
sqlstmt = "UPDATE CATEGORIES SET SUB=? , HAS_SUB=? WHERE ID=?";
pstmt = conn.prepareStatement(sqlstmt);
pstmt.setString(1,subcatids);
pstmt.setString(2,"Y");
pstmt.setString(3,selsubcat);
pstmt.executeUpdate();
There is no problem in code...and query updated successfully...
but here i want to print the 'sqlstmt' statement....to know what exactly
query contain in place of palce holder (?)...
how can print it with preparedstatement....
Reply me ASAP
Thanks
<<Less