datatable showing no data in ie 6 and 7
datatable showing no data in ie 6 and 7
shankha
Posts: 1Questions: 0Answers: 0
hi all
i am new to jquery and very very new to datatables.net
i have made a simple jsp table that retrieves data from a database table. i used datatables.net's pagination. on firefox, google chrome it works properly and shows all data with pagination. on ie 6 and ie 7 its showing "no data found". what is the problem here and how can i show the data on ie6 and ie 7? my code is given below.
[code]
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*;" %>
<%@include file="dbcon.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
JSP Page
@import "css/demo_page.css";
@import "css/demo_table.css";
@import "css/jqtransform.css";
@import "css/demo.css";
$(document).ready(function() {
$('#example').dataTable( {
"sPaginationType": "full_numbers",
"bStateSave": true
} );
} );
$(function(){
$('form').jqTransform({imgPath:'css/img/'});
});
<%
try{
%>
Parent Id
First Name
Last Name
Father or Mother
<%--
Edit this row
--%>
Edit
<%
String sql = "select * from parent";
ResultSet rs1 = stmt.executeQuery(sql);
while(rs1.next()){
%>
<%= rs1.getLong(1) %>
<%= rs1.getString(2) %>
<%= rs1.getString(3) %>
<%= rs1.getString(4) %>
<%--
Edit this row
--%>
<%--
--%>
Edit Now!
<%
}
%>
Parent Id
First Name
Last Name
Father or Mother
Edit
<%
String id = request.getParameter("id");
// out.println(id);
//stmt = null;
String showeditrec = "select * from parent where parent_id="+id;
ResultSet editrec = stmt.executeQuery(showeditrec);
while(editrec.next()){
%>
<%
}
}catch(Exception e){
e.printStackTrace();
}
%>
[/code]
thanking you
shankha
i am new to jquery and very very new to datatables.net
i have made a simple jsp table that retrieves data from a database table. i used datatables.net's pagination. on firefox, google chrome it works properly and shows all data with pagination. on ie 6 and ie 7 its showing "no data found". what is the problem here and how can i show the data on ie6 and ie 7? my code is given below.
[code]
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*;" %>
<%@include file="dbcon.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
JSP Page
@import "css/demo_page.css";
@import "css/demo_table.css";
@import "css/jqtransform.css";
@import "css/demo.css";
$(document).ready(function() {
$('#example').dataTable( {
"sPaginationType": "full_numbers",
"bStateSave": true
} );
} );
$(function(){
$('form').jqTransform({imgPath:'css/img/'});
});
<%
try{
%>
Parent Id
First Name
Last Name
Father or Mother
<%--
Edit this row
--%>
Edit
<%
String sql = "select * from parent";
ResultSet rs1 = stmt.executeQuery(sql);
while(rs1.next()){
%>
<%= rs1.getLong(1) %>
<%= rs1.getString(2) %>
<%= rs1.getString(3) %>
<%= rs1.getString(4) %>
<%--
Edit this row
--%>
<%--
--%>
Edit Now!
<%
}
%>
Parent Id
First Name
Last Name
Father or Mother
Edit
<%
String id = request.getParameter("id");
// out.println(id);
//stmt = null;
String showeditrec = "select * from parent where parent_id="+id;
ResultSet editrec = stmt.executeQuery(showeditrec);
while(editrec.next()){
%>
<%
}
}catch(Exception e){
e.printStackTrace();
}
%>
[/code]
thanking you
shankha
This discussion has been closed.