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
