[ic] inserting into userdb table through a form

Brent Kelly interchange-users@icdevgroup.org
Fri Jul 12 00:11:01 2002


Hey all,

I'm trying to modify the 'new account' page so that the user must specify=
=20
their name, company, and misc other details at the same time to create a =
new=20
account. Now i've tried this a number of ways and read all the docs i can=
 get=20
my hands on (the written manuals, and on the web) but still can't figure =
how=20
to get this going.

According to an example in the written manuals (IC 4.8 Development Guide =
-=20
p.248) the following code should be able to insert into a table on submit=
:

<FORM ACTION=3D"[process secure=3D1]" METHOD=3D"POST" name=3D"account">
[set mv_data_enable]1[/set]
<INPUT TYPE=3D"hidden" NAME=3D"mv_session_id" VALUE=3D"[data session id]"=
>
<INPUT TYPE=3D"hidden" NAME=3D"mv_data_table" VALUE=3D"userdb">
<INPUT TYPE=3D"hidden" NAME=3D"mv_data_key" VALUE=3D"username">
<INPUT TYPE=3D"hidden" NAME=3D"mv_data_function" VALUE=3D"insert">
<INPUT TYPE=3D"hidden" NAME=3D"mv_nextpage" VALUE=3D"login">
<INPUT TYPE=3D"hidden" NAME=3D"mv_data_fields"=20
VALUE=3D"title,username,password,company,fname,lname,address1,address2,ci=
ty,state,zip,country,email,phone_day,visitor">

=2E.... and then all of the form input variables for each field as specif=
ied in=20
mv_data_fields (e.g. <input type=3D"text" name=3D"company" value=3D"">).

now i know theres prolly something obvious that i'm missing but the above=
 code=20
still doesn't insert a row on submit. What i'm trying to achieve is basic=
ally=20
the standard new account page, just with the added fields.

Could someone please point me in the right direction, or in the direction=
 of=20
some docs that would.

Cheer heaps for any help,

Brent Kelly,
Zeald Ltd.