jakarta-taglibs-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 34378] New: - Date math on select with mysql jstl SQL tags not converted correctl
Date Fri, 08 Apr 2005 20:22:56 GMT
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: taglibs-dev@jakarta.apache.org
        ReportedBy: darryl@mason-nh.net


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">[B@4e8edc</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">[B@1854b38</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: taglibs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-dev-help@jakarta.apache.org


Mime
View raw message