Re: [mv] Can not update table using a form

[Ed LaFrance <edlafrance@printexusa.com>]

******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******

At 08:21 AM 3/29/00 -0500, you wrote:
>******    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]' ]">

Fevzi -

It's weird, but whenever I update a Minivend table in this fashion, I have 
to export the database file in order to see the changes - this may have 
something to do with caching, I'm not sure.  try putting this at the top of 
your check_orders.html page:

[tag export orderhdr][/tag]

Then go through the process again.  It think you will find that the changes 
show up now.

- Ed L.







><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

Printex Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
858-513-2418
800-982-1928
858-513-2419 FAX
http://www.printexusa.com

-
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