C Vivek

Thanks Janardhan,
That worked, however is there something in the code that makes it retrieve only a single record?

When I run the query in the Backend it does return the exact no of records (which can be more than 1) however in the prepared statement in the code above it is retrieving only one.

Would be glad if you can help me here.


Regards,
Vivek

public List getKw(String kw) throws SQLException { if(kw == null || kw.length() == 0) throw new SQLException(ResourceManager.getString("retrieve.kw.null")); Connection connection = getConnection(); PreparedStatement pstmt = connection.prepareStatement("select * from xyz where ItemName like('%?%');"); pstmt.setString(1,kw); ResultSet rs =pstmt.executeQuery(); List list = new ArrayList(); InfyCrDao ic = null; if(rs.next()) { ic = new InfyCrDao(rs.getInt("Sno")); ic.setSNo(rs.getInt("Sno")); ic.setItemName(rs.getString("ItemName")); ic.setItemDescription(rs.getString("ItemDescription")); ic.setDateOfInitiation(rs.getDate("DateOfInitiation")); ic.setCurrentStatus(rs.getString("CurrentStatus")); ic.setPendingWith(rs.getString("PendingWith")); ic.setRemarks(rs.getString("Remarks")); list.add(ic); } rs.close(); pstmt.close(); return list; }

The above code does not return anything in the ResultSet whereas if I hardcode value instead of the "?" in the query string, it executes properly.

Omar,

No actually, I do not want to use .xls format. even though Open Office opens .xls files. Thanks for replying though

Regards,
Vivek

Is it possible to export a table in an open office spreadsheet format?

Thanks in advance!

Hi All,
I would like to sort a column based on Milestones such as say - Under Development, Under Testing, Deployment etc.
If Under Development is state 1, Under Testing : State 2, and Deployment is State 3, How can I sort them using display tag.

Alphabetical sorting working smoothly though.

Regards,
Vivek

oops sorry.
they both point to the same url.. both point to http://10.16.58.162:18880/km/

I use Resin 2.0.5

The first time web.xml throws the custom error page upon requesting a non-existant page

say - 'http://localhost:8080/pm/d'

custom error.jsp runs

again if i say - http://10.16.58.162:18880/km/dhhh

the standard 404 html appears for future logins.

I think the web.xml still runs each time coz it does disable the directory access using the following code
<directory-servlet>none</directory-servlet>

Thanks in advance

Dear All,

I have added the following code in my web.xml
<!DOCTYPE webapp SYSTEM "http://java.sun.com/j2ee/dtds/web-app_2_3.dtd"> <web-app> <welcome-file-list>index.jsp, index.html</welcome-file-list> <error-page> <error-code>404</error-code> <location>/error.html</location> </error-page> <directory-servlet>none</directory-servlet> </web-app>

The error.html displays the first time but after the first attempt if I try to display the same page, it gives me the standard html 404 error page. The only way I get to see the page again if I make some changes to web.xml

Please could anyone help?

Regards,
Vivek

Thanks guys!

<jsp:useBean id="obj" scope="session" class="classname"/>
<%=obj.display()%>

Please could you tell me what Servlet equivalent is for the above code?

Regards,
Vivek

A Web-app in my Organisation creates some log files, which are inside its WEB-INF directory. Can I make another app within the same container to access contents within another app's WEB-INF ?

The reason I ask this is because I am not allowed to add any filters to the original app but can use the log files for further analysis. While this is currently being done manually , I would like to automate it.

How would I find out if a container is JSP2.0 and Servlets 2.3 compliant?
For example how would I know if Resin2.0.5 can handle it.

Regards,
Vivek

I have a requirement that goes as follows:

There would be a web-based application that would be built on weblogic application server. The web server would also be weblogic. The user would login into his NT machine and can then open the browser and type the URL to this web-based application. This applicaiton would only be accessible from intranet.

When the user types in the URL, there would be no login screen presented to the user. Instead, it is required that the user directly reaches the homepage of the application. Since, not all the users would have access to this application, there is a requirement to get this user's NT loginid and validate the same against the application users.

Please can anyone guide.

Thanks Bear!
Changed the code accordingly.

Thanks Ulf!! That worked smoothly too.

I have just used content-disposition in the response header to allow a download in the application.