Hi all i have sorted out the missing value app_code.Cheers if you've
being looking at it.
<b><h3>Planning Application Code
Number:<%=request.getParameter("app_code")%><input type="hidden"
name="app_code"
value="<%=request.getParameter("app_code")%>"></h3></b>
It mat not look good but it works , thus i can go on to using
<html:text/> tag instead of html tags.
Chuck Amadi wrote:
>
> 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.
--
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.
