I have Informix as a database.
Tomcat as web server.
String sortSql="select sort, match, wvg_grey_date, pro_grey_date,
processing_date,
folding_date,cutting_date,reprocess_date,sending_date,sendback_date,
grey_act_length, sent_qty,piece_status FROM pt_piece a, pp_det b where
a.pp_no = b.pp_no and a.pp_serial = b.pp_serial and a.pp_no = 'V2-P3' and
wvg_grey_date is not null and pt_prefix=div and sent_qty >0.0 order by
1,2,piece_status";
this is my qry if I mention sent qty in my qry I got right quantity.
String sortSql="select sort, match, wvg_grey_date, pro_grey_date,
processing_date,
folding_date,cutting_date,reprocess_date,sending_date,sendback_date,
grey_act_length, sent_qty,piece_status FROM pt_piece a, pp_det b where
a.pp_no = b.pp_no and a.pp_serial = b.pp_serial and a.pp_no = 'V2-P3' and
wvg_grey_date is not null and pt_prefix=div order by 1,2,piece_status";
sent_qty=rs.getFloat("sent_qty");
but while using upper qry I got all the sent_qty as 0.
I don't get why this things are happened.
I have many rows where the sent_qty = 0.0
Please send me idea if you have.
thanks in advance
Snehal
Snehal
---------------------------------------------------------------------------------------------------------
The secret of getting ahead is getting started.
The secret of getting start is
breaking your complex overwhelming
tasks into small manageable tasks,
and then starting on the first one.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
