[ic] Insert Permision?

[Ed LaFrance]

At 01:23 PM 08/15/2002 -0500, you wrote:
>That didn't do it... I added
>
><!------- Open the database -------->
>[set update_database]
>    [if type=data term="userdb::trusted::[data session username]"]
>      [set mv_database_enable]1[/set]
>    [else]
>      [set mv_database_enable]0[/set]
>    [/else]
>    [/if]
>[/set]

Oopsy - you didn't read my post too closely:

>I think you need [set mv_data_enable]1[/set] at the top of the page, or
>called from within an mv_click.
>
>- Ed L.

...also, I would just put the [set ..] at the top of the page now, for 
troubleshooting reasons.

- Ed L.



>and then
>
><INPUT TYPE=hidden NAME="mv_click"           VALUE="update_database">
>
>Still the same "Attempted database update without permission,
>table=company_info key=." error.  Any thoughts?
>
>-----Original Message-----
>From: interchange-users-admin@icdevgroup.org
>[mailto:interchange-users-admin@icdevgroup.org]On Behalf Of Ed LaFrance
>Sent: Thursday, August 15, 2002 12:39 PM
>To: interchange-users@icdevgroup.org
>Subject: Re: [ic] Insert Permision?
>
>
>At 12:04 PM 08/15/2002 -0500, you wrote:
> >Forgive me, I'm a newbie.
> >
> >I've figured out how to add a new table, I've even gotten interchange to
> >recognize the table.  I'm now trying to insert data into the table, here's
>a
> >code snippit:
> >
> >
> ><FORM METHOD=POST ACTION="[process]">
> ><INPUT TYPE=hidden NAME="mv_doit"            VALUE="return">
> ><INPUT TYPE=hidden NAME="mv_data_table"      VALUE="company_info">
> ><INPUT TYPE=hidden NAME="mv_data_key"        VALUE="username">
> ><INPUT TYPE=hidden NAME="mv_data_function"   VALUE="insert">
> ><INPUT TYPE=hidden NAME="mv_nextpage"        VALUE="signup_step4">
> ><INPUT TYPE=hidden NAME="username"           VALUE="[value username]">
> ><INPUT TYPE=hidden NAME="mv_data_fields"   VALUE="yada, yada, yada,
> >yada,....">
> >
> ><input type=text name=yada>
> >...repeated adnauseam
> >
> >
> ><INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
> ><INPUT TYPE=submit VALUE="Update table">
> ></form>
> >
> >The insert is failing, and I'm finding this in my log:
> >adsl-XX-XX-XX-XX.dsl.chcgil.ameritech.net XXXXXX:ameritech.net -
> >[15/August/2002:11:49:22 -0500] hwmpro /cgi-bin/hwmpro/process.html
> >Attempted database update without permission, table=company_info key=.
> >
> >Is this a mysql permission problem or an interchange one?  Why does it seem
> >to not know the PK?
> >
> >Thanks,
> >
> >_Am
>
>I think you need [set mv_data_enable]1[/set] at the top of the page, or
>called from within an mv_click.
>
>- Ed L.
>
>
>===============================================================
>Increase profits from your Interchange store...
>http://www.newmediaems.com/cgi-bin/nm/software_fus.html
>===============================================================
>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
>===============================================================
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

===============================================================
Increase profits from your Interchange store...
http://www.newmediaems.com/cgi-bin/nm/software_fus.html
===============================================================
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
===============================================================