Recent content by brahman

ya this solved my problem thanks a lot boss. Bye for now amit

Dear group mates, Can anybody help me out with this date conversion from ORACLE to SQL Server. I have written a query that gives me record in the specified range but am not able to get the same records in the SQL Server. Please guide me out I used Convert but it is not working fine. the...

-->times16formatNormal.setAlignment(jxl.format.Alignment.LEFT); -->Label label1 = new Label(0,4, "Organisation Name ",times16format); -->sheet.addCell(label1); how to set the column width for the column i know with this code. I am using JXL api to generate the excel sheet.

is there any way i can set the column width according to the record in the cell to fit the content. Is there any setWidth method for the column.

I tried that but it is taking c://jrun4/../servers/...../filename ../servers/...../filename this part i am giving it as prefix. where as it should take c://jrun4/server/..../filename it is taking .. extra before the path.

Dear Group Mates, I generated some files at runtime now i want to delete the same files at an instance say at logout. The path of the file is known to me and so that is not a problem, the conditions can be set on what to delete, but i dont know how to since the files are on a server. Bye for...

Dear group mates, I have done report generation in VB but am new to crystal reports can anybody help me from where can I get help to start how to use crystal reports, from begining. Thanx a lot in advance. bye for now amit

the result set is opened fetched from an SQL server recordset and than take in to a excel sheet but the formatting is not proper when i get the file. how can i set the properties directly in the JAVA code so that the resultant file contains it. bye for now amit

Dear Friends, I am opening a Excel file containing my recordsets using java , now how can I set the cell size to autofit the contents from the table. The looks are coming ugly so how to make those changes. Please guide me. Bye for now amit

Thanx a lot for the Support on this query of mine now i am able to solve the problem. And am getting the desired output. Thanx specially to alexs97,ksolos and maxpower1 bye for now amit

Ya i am doing the same but it is giving array index out of range error for the code i am giving. ---------------------------------------------------------- ArrayList ar=new ArrayList(); //ArrayList excelarray = new ArrayList(); leadhistory.setObjConnection(conbean.getConnection())...

I want to save a result set into a two dimensional array and than later do some calculation using the array columns, i tried saving the resultset in an vector but than later it would give some complexities. please help me out in this. bye for now amit

i am writing a code to find the date of coming sundays. The code is as follows. Calendar myCalendar = Calendar.getInstance(); int day=myCalendar.get(Calendar.DAY_OF_WEEK); int dateTemp=myCalendar.get(Calendar.DATE); int date=8-day+dateTemp; int year=myCalendar.get(Calendar.YEAR); int...

to get connection you can write a bean, which does it the sample for it i'll give it connects to a datasource and you use Jrun 3.1 or 4 for that. ----------------------------- package com.sysarris.model; import java.sql.*; import java.util.*; import java.io.*; import javax.sql.*; import...

thanx a lot for all the responses, now the problem is solved by the tem members cooperationa nd quick response. I thank ClaireHsu and JohnEfford for there valuable suggestions. claireHsu , since i am using htis query with JSP and beans so for the other weeks i cant use the procedure kind...