Inserting SQL data via a Form?

[Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>]

******    message to minivend-users from Nicholas Albright <albrnick@bobcat.ent.ohiou.edu>     ******


  I'm struggling (very badly, and for a while) to insert data into my SQL
database.  I tried modifying the code the gave in the example.  What I
have is shown below.  I don't get any errors at all, and I'm faily certain
that I'm interfacing to the SQL database OK, as I can see What is
currently in the table using:  [sql type=html base=ca2g_test] select *
from ca2g_test [/sql].  However, I never see the data I submitted via the
form in the table..  Any ideas?

   Thanks,
    -Nick

-----Begin Code-----
<FORM METHOD=POST ACTION="[process-target]">
<INPUT TYPE="hidden" NAME="mv_data_table" VALUE="ca2go_test">
<INPUT TYPE="hidden" NAME="mv_data_key" VALUE="internal_code">
<INPUT TYPE="hidden" NAME="mv_data_function" VALUE="insert">
<INPUT TYPE="hidden" NAME="mv_data_fields"
VALUE="internal_code,short_desc,long_desc,key_words,list_price,our_price">

Internal Code: <INPUT TYPE=TEXT NAME="internal_code" SIZE=10><BR>
Short Desc: <INPUT TYPE=TEXT NAME="short_desc" SIZE=10><BR>
Long Desc: <INPUT TYPE=TEXT NAME="long_desc" SIZE=10><BR>
Key Words: <INPUT TYPE=TEXT NAME="key_words" SIZE=10><BR>
List Price: <INPUT TYPE=TEXT NAME="list_price" SIZE=10><BR>
Our Price: <INPUT TYPE=TEXT NAME="our_price" SIZE=10>
<P>

<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE=hidden NAME="mv_doit" VALUE="set">
<INPUT TYPE=submit VALUE="Insert record">
</FORM>
-----End Code-----

-- 

"Computers in the future may weigh no more than 1.5 tons"
		-- Popular Mechanics, 1949


-
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