You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by Jack Lauman <jl...@nwcascades.com> on 2004/06/13 23:03:17 UTC
JSTL 1.0.5 Update Question
I'm using the following code to insert data from a form.
The first to fields in the data base don't come from form fields but
from entries in the web.xml file. How do you insert the web.xml value
of: <%application.getInitParameter("descriptiveName")%> when updating a
record?
<--- snip -->
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<%@ taglib prefix="x" uri="http://java.sun.com/jstl/xml" %>
<%@ taglib prefix="nwc" uri="http://nwcascades.com" %>
<html><head>
<base href="http://<%=application.getInitParameter("baseUrl")%>/">
</head>
<jsp:useBean id="now" class="java.util.Date"/>
<fmt:formatDate value="${now}" var="submit_date" pattern="yyyy-MM-dd"/>
<fmt:formatDate value="${now}" var="submit_time" pattern="HH:mm:ss"/>
<jsp:useBean id="signmeupInfo" scope="request"
class="com.nwc.biteof.forms.SignmeupInfoBean">
<jsp:setProperty name="signmeupInfo" property="*"/>
</jsp:useBean>
<c:choose>
<c:when test="${signmeupInfo.valid}">
<sql:setDataSource
var="restaurants"
dataSource="jdbc/RestaurantDS"/>
<sql:update dataSource="${restaurants}">
INSERT INTO SignMeUp
(website, code, name, cuisine, owner, address1, address2, city,
state, zip, country, email, phone, fax, message, submit_date, submit_time)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
<sql:param value="<%application.getInitParameter("descriptiveName")%>"/>
<sql:param value="<%application.getInitParameter("websiteName")%>"/>
<sql:param value="${signmeupInfo.name}"/>
<sql:param value="${signmeupInfo.cuisine}"/>
<sql:param value="${signmeupInfo.owner}"/>
<sql:param value="${signmeupInfo.address1}"/>
<sql:param value="${signmeupInfo.address2}"/>
<sql:param value="${signmeupInfo.city}"/>
<sql:param value="${signmeupInfo.state}"/>
<sql:param value="${signmeupInfo.zip}"/>
<sql:param value="${signmeupInfo.country}"/>
<sql:param value="${signmeupInfo.email}"/>
<sql:param value="${signmeupInfo.phone}"/>
<sql:param value="${signmeupInfo.fax}"/>
<sql:param value="${signmeupInfo.comments}"/>
<sql:param value="${submit_date}"/>
<sql:param value="${submit_time}"/>
</sql:update>
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: JSTL 1.0.5 Update Question
Posted by Felipe Leme <ja...@felipeal.net>.
Jack,
You need the following entry in your web.xml file:
<context-param>
<param-name>descriptiveName</param-name>
<param-value>value_of_your-parameter</param-value>
</context-param>
-- Felipe
On Sun, 2004-06-13 at 18:03, Jack Lauman wrote:
> from entries in the web.xml file. How do you insert the web.xml value
> of: <%application.getInitParameter("descriptiveName")%> when updating a
> record?
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: JSTL 1.0.5 Update Question
Posted by Jack Lauman <jl...@nwcascades.com>.
Worked great! Thanks.
Jack
Martin Cooper wrote:
>
>
> On Sun, 13 Jun 2004, Jack Lauman wrote:
>
>> I'm using the following code to insert data from a form.
>> The first to fields in the data base don't come from form fields but
>> from entries in the web.xml file. How do you insert the web.xml value
>> of: <%application.getInitParameter("descriptiveName")%> when updating
>> a record?
>
>
> <sql:param>
> <c:out value='${initParam["descriptiveName"]}'/>
> </sql:param>
>
> --
> Martin Cooper
>
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: JSTL 1.0.5 Update Question
Posted by Martin Cooper <ma...@apache.org>.
On Sun, 13 Jun 2004, Jack Lauman wrote:
> I'm using the following code to insert data from a form.
> The first to fields in the data base don't come from form fields but from
> entries in the web.xml file. How do you insert the web.xml value of:
> <%application.getInitParameter("descriptiveName")%> when updating a record?
<sql:param>
<c:out value='${initParam["descriptiveName"]}'/>
</sql:param>
--
Martin Cooper
> <--- snip -->
>
> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
> <%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt" %>
> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
> <%@ taglib prefix="x" uri="http://java.sun.com/jstl/xml" %>
> <%@ taglib prefix="nwc" uri="http://nwcascades.com" %>
>
> <html><head>
> <base href="http://<%=application.getInitParameter("baseUrl")%>/">
> </head>
>
> <jsp:useBean id="now" class="java.util.Date"/>
> <fmt:formatDate value="${now}" var="submit_date" pattern="yyyy-MM-dd"/>
> <fmt:formatDate value="${now}" var="submit_time" pattern="HH:mm:ss"/>
>
> <jsp:useBean id="signmeupInfo" scope="request"
> class="com.nwc.biteof.forms.SignmeupInfoBean">
> <jsp:setProperty name="signmeupInfo" property="*"/>
> </jsp:useBean>
>
> <c:choose>
> <c:when test="${signmeupInfo.valid}">
> <sql:setDataSource
> var="restaurants"
> dataSource="jdbc/RestaurantDS"/>
> <sql:update
> dataSource="${restaurants}">
> INSERT INTO SignMeUp
> (website, code, name, cuisine, owner, address1,
> address2, city, state, zip, country, email, phone, fax, message, submit_date,
> submit_time)
> VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?)
> <sql:param
> value="<%application.getInitParameter("descriptiveName")%>"/>
> <sql:param
> value="<%application.getInitParameter("websiteName")%>"/>
> <sql:param value="${signmeupInfo.name}"/>
> <sql:param value="${signmeupInfo.cuisine}"/>
> <sql:param value="${signmeupInfo.owner}"/>
> <sql:param value="${signmeupInfo.address1}"/>
> <sql:param value="${signmeupInfo.address2}"/>
> <sql:param value="${signmeupInfo.city}"/>
> <sql:param value="${signmeupInfo.state}"/>
> <sql:param value="${signmeupInfo.zip}"/>
> <sql:param value="${signmeupInfo.country}"/>
> <sql:param value="${signmeupInfo.email}"/>
> <sql:param value="${signmeupInfo.phone}"/>
> <sql:param value="${signmeupInfo.fax}"/>
> <sql:param value="${signmeupInfo.comments}"/>
> <sql:param value="${submit_date}"/>
> <sql:param value="${submit_time}"/>
> </sql:update>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org