Hi All,
I have problem while using prepared statements.
i have a "Select" query in a xml & i m reading it through XML parser & supplying inputs throughs prepared statements. When i execute i am not getting desired results.
Below is the snippet :
String res=query (query is String i am getting from xml file)
eg : Select * from sometable where load_date=(?) and site_num = (?)
PreparedStatement pstmt = connection.prepareStatement(res);
pstmt.setString(1, load_date);
pstmt.setString(2, site_num);
rows = pstmt.executeQuery();
I GET NO ERRORS NOTHING>>>>