This week's giveaway is in the JDBC forum.
We're giving away four copies of Java Database Connections & Transactions (e-book only) and have Marco Behler on-line!
See this thread for details.
Win a copy of Java Database Connections & Transactions (e-book only) this week in the JDBC forum!

SP Nam

Ranch Hand
+ Follow
since Oct 15, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by SP Nam

I am also planning to take SOA certification. Can somebody provide good links to study material, sample questions and exam fee details?

Thanks
Surya
Hi
I have one jsp page which shows values for id, name, Phone in text boxes.
Here id is unique and not editable. Based on id a user can edit name and Phone # and when he submits it should be updated in the db where id = xxx.


When I run this pages it is throwing Invalid Column type error.

Any suggestions please.

SP Nam
13 years ago
JSP
Hi

1.I have a jsp page which uses jstl sql tags.
2.I have 3 column table id, name, city. id will be drop down and name, city are text boxes.
3.When I load the page all ids will be shown as drop down based on select query.
4.When I select one value from id drop down, the text boxes for name and city should show corresponding values for the id selected.
5.After that user may change values of name and city.
6.After all processing when user hit submit button, the data modified in text boxes should be updated to the table.

Here is the code for my jsp page:

The critical part of it is when I select a value from id drop down, it has show values for name and city in text boxes and values can be editable.

Give me some example links or give some code snippets.

Thanks in Advance

SP Nam
13 years ago
JSP
I will go with properties files, how to got about it, where to put the property file.

SP Nam
13 years ago
JSP
Hi

I am using .ini file for some properties which are used in my jsp pages.
Where to put the .ini file as it is config file specific to web application.

Any suggestion please.

SP Nam
[ November 18, 2005: Message edited by: Bear Bibeault ]
13 years ago
JSP
Thanks Bear
I need <a> tag for one column value, when I put <a> with my code it is taking hyper link for all values.

Any code snippet Please

SP Nam
13 years ago
JSP
Hi

I am using JSTL <c:forEach> to iterate rows from a table and display on a page. I need a hyperlink for one column value.

My code is as follows:

<table border="1">
<%-- Get the column names for the header of the table --%>
<c:forEach var="columnName" items="${abc.columnNames}">
<th><c ut value="${columnName}"/></th>
</c:forEach>
<br>

<%-- Get the value of each column while iterating over rows --%>
<c:forEach var="row" items="${abc.rows}">
<tr>
<c:forEach var="column" items="${row}">
<td><c ut value="${column.value}" /></td>
</c:forEach>
</tr>
</c:forEach>
</table>

Any pointers on how to go about it.

SP Nam
13 years ago
JSP
Hi Bear

I am awfully sorry for the posting like that. I read the link which you have given and its very clear now.

As you said I will go through java.util.Calendar.

Many Thanks for the suggestion.

Really Sorry.

SP Nam
13 years ago
JSP
Hi BEAR

my question is how to show a calendar on JSP page and allow user to select a particular day as one of search criteria.

Hope this is clear now.

Thanks
SP Nam
13 years ago
JSP
Hi

I am using JSTL inside a JSP and I want to show the Calendar on it by which a user can select a particular day as a criteria.

I need to pass that date as session variable to next page.

Any suggestions.

SP Nam
13 years ago
JSP
I want to get products produced for current day, it will be on database server.

SP Nam
Hi

I want to show Date and one field value from database in a drop down. I am using jstl for this in my jsp page.
My query is like this:

select product_name from Product where production_timestamp > to_date('2005-10-25 00:00:00','yyyy-MM-dd hh24:mi:ss') and production_timestamp < to_date('2005-10-25 23:59:59','yyyy-MM-dd hh24:mi:ss')

I have to show the products produced for a particular day.

The query has to pick a current time stamp dynamically when I execute the jsp page.

Any suggestions.

SP Nam
Hi
This is my code,
any body look in and suggest
SP Name

----------------

<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>

<html>
<head>
<title>JSTL: SQL action examples</title>
</head>
<body bgcolor="#FFFFFF">

<h1>SQL Update Exec</h1>

<sql:setDataSource

var="example"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc racle:thin:@insn104a.idc.oracle.com:1522 ra9idb"
user="scott"
password="tiger"
/>

<sql:transaction dataSource="${example}">

<sql:query var="abc">
select emp_id from emp
</sql:query>

</sql:transaction>



<p>Select a Class
<select Name ="ClassDrop">
<c:forEach var="row" items="${abc.rows}">
<option><c ut value="${row.emp_id}" /></option>
</c:forEach>
</select>
<p>

<input type="submit" value="SUBMIT"/>
<input type="reset" value="RESET"/>
</body>
</html>
13 years ago
JSP
I have a jsp page and inside it I have a Select query which gets results for a table. I want to show that results as drop down box on a jsp page.

How to get the results into drop down box on a jsp page.

Any ideas.

Thanks

SP Nam
13 years ago
JSP
Hi Matt

You need to have .jar file in your WEB-INF lib.

For example, Oracle db needs classes12.jar in WEB-INF/lib folder.
For DB2 it should be different.

Thanks
SP Nam
13 years ago
JSP