[ic] inserting into a database

Dan Garwood res087jh@verizon.net
Fri, 5 Jan 2001 18:00:09 -0500


I have read and read all the docs on inserting into a database. They are
very vague on how to accomplish this outside of the userdb values. I was
trying to use the following to insert into a table. The table is seen by UI
and by interchange catalog...all is set there, I have even written partial
stuff to the table with other tags from the docs.

Here was my final attempt. I was wanting to use this way, because it allows
html tags to be kept in place up on insertion. code as follows:

<!-- main content area -->
[loop search='st=db
			  ra=yes
              fi=articles
			  ml=1
			  tf=article_id
			  to=nr
              '
	  prefix=high_code
]
			[seti current_code][high_code-article_id][/seti]
[/loop]

    <div align="center">
<TABLE size="600" cellpadding="0" cellspacing="0" border="0">
  <TR>
    <TD colSpan=2 bgcolor="#336699"><font color="#ffffff" size="1"
face="Verdana, Arial, Helvetica, sans-serif"><b>Article
Entry</b></font></TD></TR>
  <TR bgcolor="#eeeeee">
   <FORM ACTION="[process]" METHOD="post">

  <INPUT TYPE="hidden" NAME="mv_nextpage" VALUE="articleentry">
  <INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="articles">
  <INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="[current_code]">
  <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
  <INPUT TYPE=HIDDEN NAME="mv_data_fields"

VALUE="article_id,article_title,article_author,article_date,article_text,cat
_name">
  <INPUT TYPE=HIDDEN NAME="mv_data_filter_article_text" value="entities">
  <INPUT TYPE=HIDDEN NAME="article_id" value="[current_code]">
  <INPUT TYPE=HIDDEN NAME="article_date" value="[tag time]%Y%m%d
%H:%M:%S[/tag]">
    <TD align=right><font color="#000000" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><b>Category:</b></font></TD>
    <TD><SELECT size=1 name=cat_name>
	[loop search="
 st=db
 fi=articles_cat

"]
<OPTION VALUE="[item-data cat_name][loop-data articles_cat
cat_name][/item-data]"> [loop-data articles_cat cat_name]
			[/loop]
	</SELECT></TD></TR>
  <TR bgcolor="#eeeeee">

    <TD align="right"><font color="#000000" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><b>Author:</b></font></TD>
    <TD><INPUT maxLength=35 size=25 name="article_author" VALUE="[item-data
article_author]"></TD></TR>
  <TR bgcolor="#eeeeee">
    <TD align="right"><font color="#000000" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><b>Title:</b></font></TD>
    <TD><INPUT maxLength=100 size=50 NAME="article_title" VALUE="[item-data
article_author]"></TD>
	 </TR>
  <TR bgcolor="#eeeeee">
    <TD align="right" valign="top"><font color="#000000" size="1"
face="Verdana, Arial, Helvetica, sans-serif"><b>Text:</b></font></TD>
    <TD><TEXTAREA style="WIDTH: 500px; HEIGHT: 500px" name="article_text"
rows=40 cols=74 VALUE="[item-data article_text]"></TEXTAREA></TD>
	</TR>
  <TR bgcolor="#eeeeee">
    <TD colSpan=2 align="middle">
   <INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
   <INPUT type=submit value="Submit Article" name=Submit></TD>
	</TR></FORM>
	</TABLE>
	</div>