RE: Database: can't update database record (Solution)

["Yossi Cohen" <YOSSI@prodigy.net>]

******    message to minivend-users from "Yossi Cohen" <YOSSI@prodigy.net>     ******

Hi,

[loop-field] tag works with the products database only (that's a bit
inconsistent behavior which I hope will be resolved in future versions of
Minivend. Instead you can use:
[data table=inventory column=qtr key=[loop-code]]

Hope it helps.

Yossi

PS: Please categories your questions in the future.


-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of William Rothbauer
Sent: Sunday, March 07, 1999 4:29 PM
To: minivend-users@minivend.com
Subject: Re: can't update database record


******    message to minivend-users from "William Rothbauer"
<madpages@madpages.com>     ******

The error was caused by a line in Config.pm that was looking for
/usr/lib/sendmail.  I changed it to /usr/sbin/sendmail to correct the
problem.

>I'm attempting to use the update command to update a database record.
>
>/bin/update -c .....
>
>I get the following error:
>
>Can't find executable ('/usr/lib/sendmail') for the SendMailProgram
>directive
>In line 0 in the configuration file 'minivend.cfg':


I am also trying to update my inventory database with a form as follows:

<FORM METHOD=POST ACTION="[process-target]">
 <INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="inventory">
 <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
 <INPUT TYPE=HIDDEN NAME="mv_nextpage" VALUE="status">
 <INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="code">
 <INPUT TYPE=HIDDEN NAME="mv_data_fields" VALUE="qty">
 <INPUT TYPE=hidden NAME="mv_todo" VALUE="set">

[loop arg="[value update_code]"]
Current Qty <INPUT TYPE=TEXT NAME="qty" SIZE=10 VALUE="[loop-field qty]">
[/loop]

<INPUT TYPE=submit VALUE="Update table">
</FORM>

The problem I'm having is [loop-field qty] reads from the products database
instead of the inventory database and the update is not performed on the
inventory database, or the products database.  Anyone know what I'm doing
wrong.

Bill Rothbauer

-
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

-
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