RE: [dbforms] Inserts and the select tag

Joe Prosser Mon, 16 May 2005 06:04:16 -0700

Title: Inserts and the select tag

Buf if I include a tableName in the dbform tag I get this error:

javax.servlet.ServletException: Java heap space

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)

org.apache.jsp.depselect_jsp._jspService(org.apache.jsp.depselect_jsp:268)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Here is the original jsp:

<head>

<%@ taglib uri="/WEB-INF/dbforms.tld" prefix="db" %>

</head>

<body>

<h1>

Tickets form

</h1>

<db:dbform

maxRows="1"

followUp="/depselect.jsp"

autoUpdate="false"

tableName="tickets"

<!--- To force an reload event.

This is necessary because we have no given table

and needs and reload event to refetch the values of the

select boxes!

Is first parameter here because we do not have a tablename.

In this special case the hidden input field customEvent is not

rendered!

-->

<db:select

fieldName="firmt"

<db:tableData

name="firms"

foreignTable="firms"

visibleFields="name,shortdesc"

storeField="custabbrev"

</db:select>

</td>

</tr>

<db:select

fieldName="site"

<db:queryData

name="pfirms"

query='<%= "SELECT DISTINCT custabbrev,name " +

"FROM Firms " +

"WHERE " +

"parentcustabbrev = " +"'" + org.dbforms.util.ParseUtil.getParameter(request, "firmt", "-1") + "'"

%>'

</db:select>

</td>

</tr>

<db:message key="systemid"/></td><td align="left">

<db:textField styleClass="clsInputStyle" size="" fieldName="systemid"/></td>

</tr>

</table>

<br>

<db:insertButton showAlways="true" styleClass="clsButtonStyle" caption="Commit data into tickets"/>

</center>

</db:dbform>

</body>

</html>

From: Henner Kollmann [mailto:[EMAIL PROTECTED]
Sent: Monday, May 02, 2005 4:14 PM
To: Joe Prosser
Cc: [email protected]
Subject: AW: [dbforms] Inserts and the select tag

If you want to use insert you must specify a table. Otherwise dbforms do not know in which table you want to insert data.

The hidden value just refreshes the form - so which data from wich table do you show?

Why do want to insert data into an unknown table?

That can't work.

So if you want to insert data you must specify an table. You can use interceptors if you do not want the default behaviour of dbforms - generating sql insert statements.

Hope that helps

Henner

Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Joe Prosser
Gesendet: Montag, 2. Mai 2005 05:14
An: [email protected]
Betreff: [dbforms] Inserts and the select tag

Hey Folks,

I am building a form that uses dependent select tags. So in the dependent select field I use “org.dbforms.util.ParseUtil.getParameter(request,"custabbrev","-1")” in the queryData tag and “ in the primary select field’s tag.

In order to do this, I don’t specify a table in the dbform tag, and I use the hidden field with the magic value:

<input type="hidden" name="customEvent" value="re_0_0"/>

The question I have is, how do I do this on an insert form? I can’t have an insert button without a table specified in the dbform tag. Do I have to fake it some how for inserts using interceptors? If so, which button do I use?

Thanks,

-Joe

RE: [dbforms] Inserts and the select tag

Reply via email to