anandunics 0 Newbie Poster

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>>>>