Re: [ic] mv_data_function insert not working

[Mark Johnson <markj@redhat.com>]

Need 2 things. Must open the table for writing and set mv_data_enable.
Best done in an mv_click.

<input type=hidden name=mv_click value=set_db>
 .
.
[set set_db]
 [set mv_data_enable]1[/set] # Note in scratch space!
 [tag flag write]products[/tag]
[/set]

And, to be safe, you should have at the bottom of your results table

[set mv_data_enable][/set]

Mike Holmes wrote:
> 
> Hello List,
> 
> I'm trying to insert a new line into the products table, which is in a mysql
> database.  I am able to update but haven't had any luck inserting.
> This is the relevant code:
> 
> <FORM METHOD=POST ACTION="[process]">
> <INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="products">
> <INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="sku">
> <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
> <INPUT TYPE=HIDDEN NAME="mv_nextpage"      VALUE="admin/add">
> <INPUT TYPE=HIDDEN NAME="mv_data_fields"
> VALUE="sku,category,name,description,dimensions,material,mounting,color,price,wholesale,weight">
> 
> <INPUT TYPE=TEXT NAME="sku" SIZE=40 VALUE="[value sku]">
> etc..
> 
> <INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
> <INPUT TYPE=submit VALUE="Update table">
> <!-- [export products] -->
> </FORM>
> 
> Any tips?
> 
> Thanks
> Mike Holmes
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

-- 
Mark Johnson
Senior Developer - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users