Bug #85
closed
ECos Batch - Between STARTRANGE and ENDRANGE
Added by Chooi-Mey over 13 years ago.
Updated over 13 years ago.
Description
For those Sql query with "Between ? and ?" that if using preparedstatment, the set In parameter value do not require single quote (') anymore for the value. For example:
DailyReportECos.java:
private static final String STARTRANGE = "'400000000'";
private static final String ENDRANGE = "'419999999'";
The single quote defined above has been interpreted as part of the value in the SetString(1, STARTRANGE) case. Therefore no records is being found.
SO do not need single quote in this case.
Fix for all impacted program, and perform testing by compare the result with output of before migrated version.
Pls be aware that current migStore, order no has been appended with prefix 'SUF', so adjust accordingly for the testing range.
- Assignee changed from chin-yeh to Chee-Hoong
- Priority changed from Normal to Urgent
give this issue a higher priority as it's affecting the test result
single quote removed.
please list down the other related programs.
- Status changed from New to Feedback
- Assignee changed from Chee-Hoong to chin-yeh
Search thru the entire project, by using File Search with keyword "400000000", browse thru the search result, and find out any code with 'xxxRANGE' and single quote value assigned.
- Status changed from Feedback to In Progress
- Assignee changed from chin-yeh to Chee-Hoong
do search through all the files and amend the similiar changes.
if fixed and tested throughly, do deploy it to development environment so the others can verify it.
- Status changed from In Progress to Resolved
ordernum 400000000 to 419999999, single quote removed for prepareStatement.
other range is stil checking
searching order range as listed below:-
if (cntry.equals("HK"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '400000000' and '419999999'";
else if(cntry.equals("ECOS"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '0' and '400000000'";
else if (cntry.equals("AUS"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '440000000' and '449999999'";
else if (cntry.equals("IND"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '450000000' and '459999999'";
else if (cntry.equals("US"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '470000000' and '479999999'";
else if (cntry.equals("NZ"))
sqlCriteria=sqlCriteria + " and o.ORDERID between '480000000' and '489999999'";
Please let me know if any missing
all similar bug fixed. deployed to development and commited to CVS
- Status changed from Resolved to Feedback
do check and test the following program(s):
- GenOnlineOrderToWarehouseFromECosSpecial
the latest changes will be delay since my project build slow down.
class file will be upload and code to be commit into CVS soon.
all changes successfully uploaded and commited
- % Done changed from 0 to 100
- Status changed from Feedback to Closed
- Resolution set to Fixed
Also available in: Atom
PDF