Hi , I have created a submitForm.jsp that has a value parameter named
app_code that is a unique value from my PostgreSql Database. from a <sql
query/> select from my planningdb.jsp.
The app_code - is required throughout the process.(This is the Planning
Application Reference)
<sql:query>
select app_code, app_date, application_agent, grid_ref , location,
community, proposal,comment from planning_application order by 8
</sql:query>
<sql:getColumn position="1"/> retrieves the app_code ( this works).
<form action="submitForm.jsp" method="get">
<input type="submit" value="comment">
<input type="hidden" name="app_code" value="<sql:getColumn
position="1"/>
</form>
In the submitForm.jsp we have <%=request.getParameter("app_code")%>
This inserts the unique app_code ie p12121 within the submitForm.jsp,
again this works.
Thus on submitting all the other html input user values ie <input
type="text" name="first_name" align ="center"> These value are passed to
the proceessForm.jsp to my Database table (observe)and works fine except
that app_code that is <%=request.getParameter("app_code")%> this appears
in my Database as a null value.
The processForm.jsp
<sql:query>
insert into observe (first_name, last_name, address, post_code,
app_code, email,observation)
values
('<sql:escapeSql><%=request.getParameter("first_name")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("last_name")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("address")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("post_code")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("app_code")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("email")%></sql:escapeSql>',
'<sql:escapeSql><%=request.getParameter("observation")%></sql:escapeSql>')
</sql:query>
<%-- execute the query--%>
<sql:execute/>
</sql:statement>
Thus 1) how do i get the <%=request.getParameter("app_code")%> to work.
Thus 2) I have a copy of my submitForm.jsp and i am trying to invoke
<html:text/> tag to my current form. Thus am i on the right line for
input values , but how do i invoke the app_code.
User input values -
<html:text property="first_name" size="40 " maxlength="20"/>
app_code to be constant -
<html:text <%=request.getParameter("app_code")%></html:text>
Sorry if a bit long albiet i need to make progress as this needs to be
modified to struts-stubs as i am working to migrate to that example as
it has all the elements.
Cheers Chuck
--
The views expressed by the sender of this message don't
necessarily represent those of Brecon Beacons National Park
Authority. This message is intended for the addressee(s) only
and is sent in confidence; if you receive it in error, please can you
let us know (at [EMAIL PROTECTED]) and then destroy all copies.
Nid yw'r farn a fynegir gan anfonwr y neges hon o anghenraid yn
adlewyrchu barn Awdurdod Parc Cenedlaethol Bannau Brycheiniog.
Neges yw hon a fwriadwyd ar gyfer y derbynnydd/derbynyddion
yn unig ac fe'i hanfonir yn gyfrinachol; os ydych yn ei dderbyn
mewn camgymeriad, a fyddech gystal � rhoi gwybod i
ni (yn [EMAIL PROTECTED]) ac yna dil�wch bob copi.
