Hai,
thanks for your time.actually i inserted ur coding in my program but file is not having any data.pls check my previous coding,and tell me where i have do modification and where i have to insert ur codings..pls help me.
<%
FileOutputStream outfile;
PrintStream p,p1;
outfile= new FileOutputStream("d:\\temp\\error1.txt");
outfile= new FileOutputStream(filename);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:pro","pro","pro");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from CSG where Module='7613-slot6' ");
p = new PrintStream(outfile);
p.println(" Module DateTime Allocated Memory Available Memory
OsStaic Memory");
while(rs.next())
{
String date=rs.getString(1);
String time=rs.getString(2);
String availablememory=rs.getString(3);
String allocatedmemory=rs.getString(4);
String osstatic=rs.getString(5);
p.println(" "+date+" "+time+" "+availablememory+"
"+allocatedmemory+" "+osstatic+" ");
}
%>
thanks a lot
Regards
Babu