[ic] Insert Permision?

[Andrew Metcalfe]

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]

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