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=34378>. 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=34378 Summary: Date math on select with mysql jstl SQL tags not converted correctl Product: Taglibs Version: 1.2.0 Platform: Other URL: http://dax.shecora.com:8080/CanopyStats/Detail.do?mac=0a -00-3e-90-22-0d&op=h OS/Version: other Status: NEW Severity: normal Priority: P2 Component: DBTags Taglib AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] Not sure if this is the correct location for this bug. The sql command is: select ap,name,date_format(dtg,'%c/%d %h %p') as hr, max(session_cnt)- min(session_cnt) as scnt, max(reg_cnt)- min(reg_cnt) as rcnt, max(re_reg_cnt)- min(re_reg_cnt) as recnt from reading where mac = '0a-00-3e-90-22-0d' group by name,hr order by hr desc which create output like: <tr> <td>Hilltop AP</td> <td> Hoffman Family</td> <td align="left">[EMAIL PROTECTED]</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> </tr> <tr> <td>Hilltop AP</td> <td> Hoffman Family</td> <td align="left">[EMAIL PROTECTED]</td> <td align="right">0</td> <td align="right">0</td> <td align="right">0</td> </tr> -- 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]
