Hi Ivan, Sounds really strange... I haven't change something in the search code since december..
If you can not reproduce this behaviour in the bookstore example your test pages would'nt help. Do you have the same problem in your test enviroment? If yes - could you use the sources instead of the jar file and try to debug whrere the student code is lost? I needed i can help you to find the right starting point for debugging. Hope to help, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Ivan Codarin > Gesendet: Freitag, 4. M�rz 2005 21:20 > An: [email protected] > Betreff: [dbforms] [Bug?] Very strange problem with final 2.5 > and search fields. > > Dear All, > I have a very strange problem with dbforms2.5. > I'm upgrading my production system from the > dbforms2.5snapshot of December 2004 to the final release. > I enclose to this mail my JSP page and 2 pieces of my dbforms config. > I have also created a similar example on bookstore (but in > that case all the things run well)... > I could send you also that files to extend the "tests" folder... > > > I have the main form that uses two searchCombos to search (1) > a student and (2) an academic year. > The subform is related to the first one through > (studentcode,academicyear) attribs. > > The problem is that when I select a student from the > searchCombo my database > (postgresql) logs this two queries: > > > > (1) For the MAIN FORM: > > SELECT studentcode, lastname, firstname, courseyear, > academicyear > FROM enrolment_pinfo WHERE ( ( (studentcode = > 'AD03MROS' AND academicyear = 2003 ) ) ) > > [this is as expected the query to extract a specific > student in a specific academic year. > > (2) The strange thing is that for the SUBFORM: > > SELECT studentcode, academicyear, subjectlevel, > subject, date_start, date_end, updatedate, lastusermod > FROM study_plan WHERE ( ( ( academicyear = 2003 ) ) ) > > [in this case dbform loses the studentcode part in > the whereString] > > The very strange thing is that the December Version (of > course 29 december 2004) is ok and works well with the same > page simply using the "old" jar file. > > Is this a bug? Is this a problem related to my form or > related to the use of search fields? > > > I created a "similar" example for bookstore but in that case > I'm not able to generate the same situation.... > (Henner or other developers do you need it? I could zip it > and send to you the hsqldb file, jsp and dbforms-config.xml). > > > Has anyone an idea? Now I will restore my configuration with > the December version, but I would like to solve this issue... > > Thank you. > Ivan ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
