MiniVend Akopia Services

[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


Search for: Match: Format: Sort by: