[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Inserting into SQL Database from MiniVend
Hello,
Does anyone know why the first section of code works
<FORM ACTION="[process-target]]" METHOD=POST>
<INPUT TYPE="hidden" NAME="mv_data_table" VALUE="tmpjtbmlinks_tbl">
<INPUT TYPE="hidden" NAME="mv_data_key" VALUE="tmplinkname">
<INPUT TYPE="hidden" NAME="mv_data_function" VALUE="insert">
<INPUT TYPE="hidden" NAME="mv_data_nextpage" VALUE="inserted">
<INPUT TYPE="hidden" NAME="mv_data_fields" VALUE="tmpLinkName, tmplinkurl, tmplinkpic, tmpcountry, tmpstateprov, tmpcitytown, tmpplace, tmpdes, tmplinkcomment">
<INPUT TYPE="text" NAME="tmplinkname" VALUE="[value tmplinkname]" size=55>
<INPUT TYPE="text" NAME="tmpjtbmlinkurl" VALUE="http://www." size=55>
<INPUT TYPE="text" NAME="tmpcountry" VALUE="[value tmpcountry]" size=40>
<INPUT TYPE="text" NAME="tmpstateprov" VALUE="[value tmpstateprov]" size=40>
<INPUT TYPE="text" NAME="tmpcitytown" VALUE="[value tmpcitytown]" size=40>
<INPUT TYPE="text" NAME="tmpdes" VALUE="[value tmpdes]" size=55>
<INPUT TYPE="text" NAME="tmplinkcomment" VALUE="[value tmplinkcomment]" size=55>
<INPUT TYPE="submit" NAME="mv_todo" VALUE="Set">
</FORM>
and this code below reports that it can't find the "reviewprod_tbl" database in
the products directory ? The products database is an SQL database as well as
both of these. These forms are on different pages with the standard tops sides
and bottoms.
<FORM ACTION="[process-target]" METHOD=POST>
<INPUT TYPE="hidden" NAME="mv_data_table" VALUE="reviewprod_tbl">
<INPUT TYPE="hidden" NAME="mv_data_key" VALUE="reviewnumber">
<INPUT TYPE="hidden" NAME="mv_data_function" VALUE="insert">
<INPUT TYPE="hidden" NAME="mv_data_nextpage" VALUE="inserted">
<INPUT TYPE="hidden" NAME="mv_data_fields" VALUE="reviewnumber, productid, artistname, producttitle">
[item-list]
[sql type=list query="select productid artistname, producttitle from products where productid='[item-code]'"]
<INPUT TYPE="hidden" NAME="productid" VALUE="[sql-param productid]">
<INPUT TYPE="hidden" NAME="producttitle" VALUE="[sql-param producttitle]">
<INPUT TYPE="hidden" NAME="artistname" VALUE="[sql-param artistname]">
{/sql]
[/item-list]
[sql type=list
query="select max(reviewnumber) from reviewprod_tbl"]
<INPUT TYPE="hidden" NAME="reviewnumber" VALUE=[calc][sql-param code]+1[/calc]>
[/sql]
<TEXTAREA NAME=review_message COLS=45 ROWS=15></TEXTAREA>
<INPUT TYPE="submit" NAME="mv_todo" VALUE="Set">
</FORM>
Any help will be appreciated.
I've got
RH5.2
Postgres 6..5 .1
MiniVend 3.14-3
Thanks
Karl