I have been trying to write an updatable report (or manual tabular form), using a radio button as the row selector. The radio button is defined as the following HTML expression:
<input type="radio" name="f11", value="#ROWNUM#">
The I am having problems in regard to paging. (By the way, I get the same problem with a checkbox instead of a radio button.) Everything works fine on the first page. But when I go to other pages, there is a problem. Suppose I select the 17th record, which is the second record of the second page. The value of the array g_F(11) is 17, but that doesn't help me. I need the index 2, not 17. I can solve the problem by storing the rownum of each record in a hidden item and then subtracting the rownum of the first value in the array from the 17, but this seems inelegant. There must be a better way.
For example, the row selector used in a tabular form doesn't have this problem. What is it doing that I don't know about? How does it get the correct "relative" row number of a record on a page instead of the "absolute" row number?
PLEASE DO NOT CREATE A NEW THREAD ON THE SAME SUBJECT YOU ALREADY HAVE A THREAD OPEN FOR... It is wasteful of our time and will cause less people to want to help you in regards to your issue.. I would SUGGEST that you append this information to your existing thread and see if people will respond accordingly..
OK, I figured out the issue. My HTML code works fine. The problem was that I hadn't understood the difference between the use of ROWNUM in the SQL source query and the built-in substitution string #ROWNUM#. So what I had done was put ROWNUM as one of the fields of the query, which of course meant that #ROWNUM# now referred to that field instead of the built-in substitution string. Duh.