MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and d.id = w.district and t.id = w.tehsil' at line 1 Watercourse.getAddressselect w.serial, w.wc_number, w.village, w.distrib_minor, d.name as dname, d.id as district_id, t.name as tname, t.id as tehsil_id, field_team_name, saline_water, barani from watercourse w, district d, tehsil t where w.serial = and d.id = w.district and t.id = w.tehsilMEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Watercourse.getWuaselect * from wc_wua where wc_serial=MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Watercourse.getStatusselect servay_conducted, design_approval, date_format(initiation_dt, '%d-%c-%Y') as initiation_dt, date_format(icr1_dt, '%d-%c-%Y') as icr1_dt, date_format(icr2_dt, '%d-%c-%Y') as icr2_dt, date_format(completion_dt, '%d-%c-%Y') as completion_dt, date_format(verified_dt, '%d-%c-%Y') as verified_dt, hq_visits, rm_visits, arm_visits, carried_over from wc_status where wc_serial=MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 Watercourse.isVerifiedselect if (verified_dt <= curdate(), 1, 0) as verified from wc_status where wc_serial=MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 Watercourse.isCompletedselect if (completion_dt <= curdate(), 1, 0) as completed from wc_status where wc_serial=MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Watercourse.getFundsselect wc_serial, truncate(farmer_share1, 0) farmer_share1, truncate(farmer_share2, 0) farmer_share2, truncate(govt_share1, 0) govt_share1, truncate(govt_share2, 0) govt_share2, truncate(govt_share3, 0) govt_share3, truncate(estimated_cost, 0) estimated_cost, truncate(ts_amount, 0) ts_amount, date_format(ts_dt, '%d-%c-%Y') as ts_dt, truncate(revised_cost, 0) revised_cost, truncate(actual_cost, 0) actual_cost from wc_funds where wc_serial=MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and updated = (select max(updated) from wc_progress where wc_serial=)' at line 1 Watercourse.getProgressselect date_format(updated, '%d-%c-%Y') as updated, earthen_imprv, brick_lining, pcpl, nukka_20, nukka_24, culverts, other from wc_progress where wc_serial= and updated = (select max(updated) from wc_progress where wc_serial=)MEException: [2]: Query was not successful. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Watercourse.getPlanselect * from wc_plan where wc_serial= View Individual Watercourse Status

Show Printable View

FirstPreviousNextLast1 of 0

Watercourse Location
Watercourse Number   Village  
Distributory/Minor   Field Team  
Tehsil   District  
Watercourse Attributes
Water User's Association
Status
Incomplete 
Registration No. & Date
 
Water Quality
Sweet Water
Chairman
 
Survey Conducted
 
Share Holders
 
Design Approved
 
Treasurer
 
Project Duration
Initiation:
Account Number
 
Completion:
Branch
 
Estimated Cost
0
   
Technical Sanction
Date:  
 
 
Amount: 0.00000  Mil
Carried Over:
Financial Status
Farmer's Share Amount (Millions) Government Share Amount (Millions)
First
0.00000 
First
0.00000 
Second
0.00000 
Second
0.00000 
Third
0.00000 
Total
0.00000
Total
0.00000
Grand Total
0.00000
Civil Works Status
Earthen Improvent Total Lining Nukka 20" Nukka 24" Culverts Others
Planned          
Executed          

FirstPreviousNextLast1 of 0

 

Copyright © 2005-2010, PMU National Program for Improvement of Watercourses, Punjab Component.