[ic] database insert through form

Dennis Schoen dennis@cobolt.net
Wed, 25 Apr 2001 11:25:08 +0200


Hi all,

i've a problem using Interchange to insert entries into my Database.

when i use the following code:

<form method="post" action="[process]">
<input type=hidden name="mv_session_id" value="[data session id]">
<input type=hidden name="mv_todo" value="set">
<input type=hidden name="mv_data_function" value="insert">
<input type=hidden name="mv_data_table" value="dealings">
<input type=hidden name="mv_data_key" value="idf">
<input type=hidden name="mv_data_fields"
value="goodsidf,parent,price,offerer,firstoffer,info">
<input type=hidden name="mv_nextpage" value="dealings">
[...]
<input name="info">
Response Price:
<input name="price">
<input type=hidden name="offerer" value="[data session username]">
<input type=hidden name="goodsidf" value="[loop-param goodsidf]">
<input type=hidden name="parent" value="[item-param idf]">
[...]
<input type=submit name="mv_click" value="[L]Submit[/L]">
</form>
[set [L]Submit[/L]]
[set mv_data_enable]1[/set]
[/set]

the insert works perfectly. However i just want it to insert the
entry if at least "info" or "price" are set.

Is there a way to tell Interchange only to insert the entries where
either the "info" or the "price" field are set?

Dennis
-- 
"Contrary to popular belief, UNIX is a user-friendly Operating
System. It's just choosy about who its friends are."