Mailing List Archive

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>