To most this data entry page probably looks like a piece of cake, but for our group it was a headache. We couldn't figure out why the dropdown list wouldn't populate: our SQL statement looked fine; the source showed the XML results; and all other page elements appeared correctly. Why wouldn't the field populate? Mind you that this specific dropdown list is not dependent on the sequencing concept demonstrated using "customerid" in the example code.
The SQL statement to fill the dropdown list only involved getting data from one field (select mission "mission" from org_missions) so I thought, "what if I repeated the mission part?" Sure enough, select mission "mission", mission "mission from org_missions did the trick. Why is this? I tried this based on trial and error/dumb luck. I imagine it has something to do with dropDown.xsl and relative locations/XPath therein, but I'm not completely sure. The answer to this question isn't pressing but just a bit of a wonder.
Comments