[ic] table update via form not working as expected

Thanh Luong interchange-users@icdevgroup.org
Tue Dec 17 11:04:00 2002


--- 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.

Thanks,
Tom

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com