[mv] Can not update table using a form

["Fevzi ALIMOGLU" <falimoglu@SUNAPEE.cambridgeis.com>]

******    message to minivend-users from "Fevzi ALIMOGLU" <falimoglu@sunapee.cambridgeis.com>     ******

X-No-Archive: Yes

I have an order database called orderhdr.* with only two fields: code and
status. I modified query/check_orders.html page such that I can see a list
of all orders with links.

When I click on any one of them I see details about that specific order.
(Order details (items) are store in another database called orderitem.*) In
this page, (query/resultitem.html) I would like to have a form that would
allow me to update the order status. However for some reason the
status.values does not change.

Here is what I have in query/check_orders.html
...
[tag each orderhdr]
[sort orderhdr:code]
[page scan
        sp=query/resultitem.html
        fi=orderitem
        st=db
        sf=ordernum
        se=[loop-code]
]
[loop-code]
[/page]
[data base=orderhdr field=status key=[loop-code] ]<BR>
[/tag]

In the query/resultitem.html, I have:
Order: [value mv_searchspec]
<P>
<FONT SIZE="2">
<FORM METHOD=POST ACTION="[process-target]">
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="orderhdr">
<INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="code">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
<INPUT TYPE=HIDDEN NAME="mv_data_fields"   VALUE="status">
<INPUT TYPE=HIDDEN NAME="mv_nextpage"      VALUE="query/check_orders.html">

New status <INPUT TYPE=TEXT SIZE=10 NAME="status"
VALUE="[data base=orderhdr field=status key='[value mv_searchspec]' ]">

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

[search-region send=1]
[search-list]
  [item-code]: belongs to
  [item-data orderitem ordernum]<BR>
[/search-list]
[/search-region]


Please help me

Thank you
FA




-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list