[ic] I can't delete a records from the database xyz!

Ed LaFrance interchange-users@interchange.redhat.com
Fri Dec 7 12:08:01 2001


At 04:55 PM 12/07/2001 +0100, you wrote:
>Joachim Leidinger <jojo@blackpoint.de> writes:
>
> > "Stefan Hornburg (Racke)" wrote:
> > >
> > > Joachim Leidinger <jojo@blackpoint.de> writes:
> > >
> > > > Hi List,
> > > >
> > > > in old MV Shop, I've
> > > >
> > > >     <INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="anmelden">
> > > >     <INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="[scratch code]">
> > > >     <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="delete">
> > > >     <INPUT TYPE=HIDDEN NAME="mv_data_verify" VALUE="1">
> > > >
> > > > to remove a record from the database "anmelden". After updating to IC
> > > > 4.8.3, that codes is not working now.
> > >
> > > What says the error log ?
> >
> > Nothing! Remember! I was your student! If there is any error messages, i
> > would post this message with my email too. :-)
>
>Hm, then it is hard to guess. I'm using SQL database most of the times.
>
> >
> > > > The codes
> > > >
> > > > [delete_record table="anmelden" key="[scratch code]"]
> > >
> > > This is no IC tag.
> >
> > Right! It was for the old MV! I try out to find a right IC codes/Tag for
> > the above tag! What is the right codes to remove a row from the table
> > "anmelden.asc"? Looking in UI with flex_select, I'm able to remove a row
> > from the table "anmelden". But the row has to be removed automatically
> > on my next IC page after any submitting.
>
>[perl tables=anmelden]
>$Db{anmelden}->delete_record($Scratch->{code});
>[/perl]
>
>You need to do the export stuff too.
>
>Ciao
>         Racke

 From the docs on Updating Database Tables with a From (I really don't know 
how relevant this is anymore):

mv_data_enable (scratch)

\IMPORTANT: This must be set to a non-zero, non-blank value in the scratch 
space to allow data set functions. Usually it is put in an mv_click that 
precedes the data set function. For example:
             [set update_database]
             [if type=data term="userdb::trusted::[data session username]"]
                 [set mv_data_enable]1[/set]
             [else]
                 [set mv_data_enable]0[/set]
             [/else]
             [/if]
             [/set]
             <INPUT TYPE=hidden NAME=mv_click VALUE=update_database>


More here:

http://interchange.redhat.com/cgi-bin/ic/dev-4.8/ictemplates_40.html


- Ed L.



===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================