DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=37254>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=37254 ------- Additional Comments From [EMAIL PROTECTED] 2005-11-21 07:46 ------- You're right. Some preliminary testing showed it worked and I assumed that if another store one used it, it must be ok. Here's my current one, although I agree that it should be handled in java code. It basically sorts by the branch, then major, then minor and seems to work ok. protected String convertRevisionNumberToComparable(String revisioNumber) { return "substr("+revisioNumber+",1,instr("+revisioNumber+",'.',-1,2)-1)," + "to_number(substr("+revisioNumber+",instr("+revisioNumber+",'.',-1,2)+1," + "instr("+revisioNumber+",'.',-1)-instr("+revisioNumber+",'.',-1,2)-1))," + "to_number(substr("+revisioNumber+",instr("+revisioNumber+",'.',-1)+1))"; } -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
