[ic] Updating Database with Form Data

[Jim Sustacek]

I got this to work on the "order_view" page, updating the field "comments" in my database "transactions", but then it quit working.  Why is this?  Here is the section of code I added to the file, and "loop-code" is still the correct index for the order.  Is there something I need to add or change to make this work consistently?

<FORM METHOD=POST ACTION="[process]">
   <INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="transactions">
   <INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="code">
   <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
   <INPUT TYPE=HIDDEN NAME="mv_nextpage"      VALUE="__UI_BASE__/order_view">
   <INPUT TYPE=HIDDEN NAME="mv_data_fields"
               VALUE="code,comments">
   <PRE>

   [loop arg="[loop-code]"]
   Sales Order <INPUT TYPE=TEXT NAME="code"    SIZE=10 VALUE="[loop-code]">
      Comments <INPUT TYPE=TEXT NAME="comments"
                   SIZE=30 VALUE="[loop-field comments]">
   [/loop]
   </PRE>

       <INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
       <INPUT TYPE=submit VALUE="Update table">
   </FORM>

-- Jim Sustacek
jim@computercasesandcables.com