[ic] table update via form not working as expected

[interchange-users@icdevgroup.org (Stefan Hornburg)]

On Tue, 17 Dec 2002 08:02:47 -0800 (PST)
Thanh Luong <j0wsty1ls@yahoo.com> wrote:

> 
> --- Stefan Hornburg <racke@linuxia.de> wrote:
> > On Tue, 17 Dec 2002 07:22:12 -0800 (PST)
> > Thanh Luong <j0wsty1ls@yahoo.com> wrote:
> > 
> > > I have been trying to update my table via a form. I have followed
> > the
> > > example in the docs and made my code as close to the docs as I
> > could.
> > > I have the following code
> > > 
> > > [set update_database]
> > >  [set mv_data_enable]1[/set]
> > > [/set]
> > > 
> > > <FORM ACTION="[process secure=1]" METHOD="POST">
> > > <INPUT TYPE=hidden NAME="mv_session_id" VALUE="[data session id]">
> > > <INPUT TYPE=hidden NAME="mv_click" VALUE="update_database"> 
> > > <INPUT TYPE=hidden NAME="mv_todo" VALUE="set"> 
> > > <INPUT TYPE=hidden NAME="mv_nextpage" VALUE="car_of_the_week">
> > > <INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="car_of_the_week_db">
> > > <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
> > > <INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="code">
> > > <input type=hidden name="mv_data_fields" value="code,img_back">
> > > 
> > > <pre> 
> > > [loop arg=|
> > >   fi=car_of_the_week_db
> > >   sf=code
> > >   se=10064
> > >     |]
> > > <input type=hidden name="img_back" value="tom">
> > > [/loop]
> > > </pre>
> > > <input type=submit>
> > > </form>
> > > I have been trying to troubleshoot a larger problem for a while now
> > and
> > > I this form submission is part of the problem. I use to have
> > variables
> > > in the form but removed them for debugging and appearently it wasnt
> > my
> > > variables that did not allow the form to submit to update my table.
> > > Does anyone have any clues to offer.
> > 
> > Anything in your error.log's ?
> > 
> > Ciao
> >         Racke
> my error log says
> 
>  - [17/December/2002:11:29:21 -0500] riptshop
>  /cgi-bin/riptshop/11.html search error: Search strings must be at
> least 1 characters.
> > You had no search string specified.
> >
>  - [17/December/2002:11:29:23 -0500] riptshop
>  /cgi-bin/riptshop/process.html No key 'code' found for
> function='update' table='car_of_the_week_db'
> Those errors dont make much sense to me. I have specified mv_data_key
> and there is an mv_searchspec in the code. maybe you can make something
> out of them.

The mv_searchspec won't help. IC cannot read your thoughts

You need to add:

<input type=hidden name=code value="10064">

You need to specify the key value with the code CGI parameter.

Ciao
        Racke