I will prepare an example based on bookstore in the next days. I solved dhe problem with 2 sub-forms (is very inefficient!) and now it's working. Thanx
> Hi Ivan, > > Please could you make an example based on the bookstore example to > reproduce the effect? > > So we can debug it. > > Thanks, > Henner > >> -----Urspr�ngliche Nachricht----- >> Von: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Im >> Auftrag von Ivan Codarin >> Gesendet: Montag, 29. September 2003 05:56 >> An: [EMAIL PROTECTED] >> Betreff: [dbforms] disperated: select + tableData (or >> queryData) problem! >> >> >> Hi all, >> jdbform is very nice... but I've a complex feeling with it! >> [i use 1.1.4pr1 of 2003-09-20] >> I've produced a form where I use a tecnique like in >> howtoChangeSelectBox.jsp example to change the contents of >> the form. I've a session that loads a selectBox with >> particular values, then when I change this selectBox the form >> is submitted to change another subform with the correct data. >> [I'll put the source code at the end of this post.] >> >> The subform displays the records of a table with a particular >> whereClause. >> >> I've a table "student_grade" where every student's grade is >> taked from another table named "tbl_grade". >> >> My problem is on the select with tableData based on >> "tbl_grade". The selectBox is rendered correctly with all the >> values of the "tableData tbl_grade" displayed with the >> "decoded value", but this values aren't matched with the >> record of "student_grade" contents. So I've a long table >> where the contents of selectBox is the same for every record >> and if i print out the coded valued (the value in the table) >> it is different from "decoded value" taked from tableData. >> >> My english is very poor, i hope you understand me. >> I tried to disable caching with disableCache="true" in >> tableData TAG, but i didn't have any result.... >> >> I must put this page in work in two days, I'm disperated. >> >> Many thanx >> >> ---- PARTIAL SOURCE CODE OF THE PAGE --- >> <db:dbform >> maxRows="*" >> bypassNavigation="true" >> >> followUp="business_objects/navigation_test/howtoChangeSelectBox.jsp" >> autoUpdate="false" >> > >> <!--- 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! >> --> >> <input type="hidden" >> name="customEvent" value="re_0_0"/> >> >> <!-- PRIMA SELECT BOX - SCELTA TEACHER - --> >> <% >> String user= >> (String)session.getValue("loginName"); >> >> out.println("Welcome, "+ user); >> /* >> >> String class=(String)session.getValue("classCode"); >> >> String qry_class=new String("SELECT DISTINCT classcode, >> classcode FROM teching_block "); >> >> if (class==null) >> { >> >> qry_class = qry_class + " WHERE teacher = '" + >> user + "'"; >> } >> else >> { >> >> } >> */ >> %> >> >> <!-- SECONDA SELECT BOX - >> SCELTA CLASS - --> >> Class choice >> <db:select >> fieldName="classcode" >> >> onChange="this.form.submit();" >> > >> <db:queryData >> >> name="ext_classcode" >> >> query='<%= "SELECT DISTINCT classcode, classcode " + >> >> "FROM teaching_block " + >> >> "WHERE teacher= '" + user +"'" >> %>' >> >> /> >> </db:select> >> >> <!--------------------------- SUB FORM >> ----------------------------------------------> >> <db:dbform >> maxRows="*" >> >> followUp="business_objects/navigation_test/howtoChangeSelectBox.jsp" >> autoUpdate="true" >> tableName="student_grade" >> whereClause='<%= "WHERE classcode = '" + >> >> org.dbforms.util.ParseUtil.getParameter(request, "classcode", "-1") >> +"'"%>' >> > >> <db:header> >> <table align="center"> >> <tr> >> <td>S.</td> >> <td>S.Code</td> >> <td>Class</td> >> <td>Year</td> >> <td>Term</td> >> <td>Effort</td> >> <td>Achiev.</td> >> >> <td>Acad.year</td> >> >> </tr> >> </db:header> >> <db:body> >> <tr> >> >> <td><db:associatedRadio name="r_Studentcode"/></td> >> >> <td><db:label fieldName="studentcode"/></td> >> >> <td><db:label fieldName="classcode"/></td> >> >> <td><db:label fieldName="courseyear"/></td> >> <td> >> >> <db:select fieldName="term"> >> >> <db:staticData name="termineFisso"> >> >> <db:staticDataItem key="OCT_1" value="October"/> >> >> </db:staticData> >> >> </db:select> >> >> </td> >> <td> >> >> <db:select fieldName="effortgrade"> >> >> <db:queryData >> >> name="ext__EF_grades" >> >> query='<%= "SELECT DISTINCT id_grade, textualnumber" + >> >> " FROM tbl_grade " + >> >> " WHERE gradetype = 'EF'" >> >> %>' >> >> disableCache="true" >> >> /> >> >> </db:select> >> >> </td> >> <td> >> >> <db:label fieldName="achievmentgrade"/> >> </td> >> <td> >> >> <db:select fieldName="achievmentgrade"> >> >> <db:tableData >> >> name="ac_grade" >> >> foreignTable="tbl_grade" >> >> visibleFields="textualnumber" >> >> storeField="id_grade" >> >> disableCache="True" >> >> /> >> >> </db:select> >> >> </td> >> >> <td><db:label fieldName="academicyear"/></td> >> >> <td><db:updateButton >> followUp="/business_objects/navigation_test/howtoChangeSelectBox.jsp" >> styleClass="clsButtonStyle" caption="Update" >> src="/uwcad/pics/buttons/update.png" >> associatedRadio="r_Studentcode" flavor="image" caption="Save"/></td> >> </tr> >> </db:body> >> <db:footer> >> <tr align="center"> >> <db:updateButton >> followUp="/business_objects/navigation_test/howtoChangeSelectBox.jsp" >> styleClass="clsButtonStyle" flavor="image" caption="Save"/> >> <td align="center"> >> </td> >> </tr> >> </table> >> </db:footer> >> </db:dbform> >> >> </db:dbform> >> >> >> >> >> ------------------------------------------------------- >> This sf.net email is sponsored by:ThinkGeek >> Welcome to geek heaven. >> http://thinkgeek.com/sf >> _______________________________________________ >> DbForms Mailing List >> > http://www.wap-force.net/dbforms > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
