Search results for query: *

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...

thanx a lot boss for the immediate and accurate reply. Well now i need to modify it again for the loop i.e. on every request a user should get the next weeks record. The result starts with the comming sunday to saturday but for next request it should be the second sunday to second satruday...

I am writing a sql query which can fetch me record ranging from comming sunday to saturday. the search date can be any date and the sunday should be the very next coming sunday. or in other simple words i want the records for the coming week starting from sunday and ending at saturday. i am...

now i have rectified the problem of migrating database from Oracle to MS SQL . So would be available for solution if anybody else need it. bye for now amit

actually i was calling a function onBlur of window and so it was closing it now it is Ok and working fine. Thanks a lot for your response.

I am having problem exporting oracle database to SQL server2000. The problems are like the change in the attribute field types etc. kindly help me in rectifying the problem. bye for now amit