Hey guys, actually I am trying to print a report from jasper with netbeans, when I press the button it will promote the message
Unknown column name copyprices_id_no in result set , although I double checked db fields,

my jasper query is as follows

 
 
    JRDesignQuery jquery = new JRDesignQuery();
 
    jquery.setText("SELECT * FROM copyprices WHERE id_no = 1");
 
   js.setQuery(jquery);



What I think is the syntax problem, is their a way to pass a the sql query to jasper rather than my method, plz help me to sort it out