[ic] SQL insert with a form

[Dorothy Puma]

Thank you for responding!
It's a mySql database. I know it's not permissions on the mySql database, 
because I can insert into the database using the
[query sql="INSERT INTO Tkt SET customerName='[value customerName]', 
timeTkt='[value timeTkt
]';"]
command. I can also see that Interchange is not even trying to connect into 
the mySql database, I have logging turned on and can see all requests on 
the database, and nothing.

The only problem that I have with the [query sql="INSERT INTO (etc) ] 
command, is getting the single quotes escaped out before it is written to 
the database. So, I was trying to use the mv_data_function commands 
instead. Any ideas??

Thanks,
Dorothy

At 05:21 PM 11/19/01, cfm@maine.com wrote:
>On Mon, Nov 19, 2001 at 03:33:40PM -0800, Dorothy Puma wrote:
> > I have gone over the mailing lists and the docs on how to insert into a
> > table with a form. I have followed the instructions for UPDATING a
> > database
> > with a form at:
> > 
> http://interchange.redhat.com/cgi-bin/ic/docfly.html?mv_arg=ictemplates10%2e09,
> > but I get an "Attempted database update without
> > permission". Searching through the maillist, the answer to that question
> > is to have mv_data_enable set to 1, which I do, and I still get nothing.
> > Below
> > is what I have in my form, can someone PLEASE help me.
>
>
>You can get permission denied for a number of reasons.  Is that
>an sql database or a local dbm?  What are the permissions of the database?
>
> >
> > Thank you,
> > Dorothy Puma
> >
> > [set mv_data_enable]1[/set]
> > <FORM METHOD=POST ACTION="[process-target]">
> > <INPUT TYPE=HIDDEN NAME="mv_nextpage" VALUE="serviceticket2-sent">
> > <INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="Tkt">
> > <INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="tktnum">
> > <INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
> > <INPUT TYPE=HIDDEN NAME="mv_data_fields"
> > VALUE="customerName,HelpDeskNum,serviceDate,LocationWork,AfterHours,
> > servicePerformed,host,domain">
> > <INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> > http://interchange.redhat.com/mailman/listinfo/interchange-users
>
>--
>
>Christopher F. Miller, Publisher                               cfm@maine.com
>MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
>1.207.657.5078                                         http://www.maine.com/
>Content/site management, online commerce, internet integration, Debian linux
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users