[ic] Insert Permision?

Ed LaFrance interchange-users@icdevgroup.org
Thu Aug 15 13:40:00 2002


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="update">
><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
===============================================================