macromedia flash flash remoting: PLEASE HELP: I get a Error Executing Database Query when I try an INSERT SQL
Query via this Coldfusion MX 7 CFC. If I change the query to a SELECT query
everything works fine. <cfcomponent> <cffunction name='myFunction'
access='remote' output='false'> <cfargument name='Products' type='string'
required='yes'> <cfargument name='Prod_Des' type='string' required='yes'>
<cfargument name='Prod_Color' type='string' required='yes'> <cfargument
name='InStock' type='string' required='yes'> <cfquery name='Recordset1'
datasource='remoting'> INSERT INTO Prod_tbl VALUES ('#ARGUMENTS.PRODUCTS#',
'#ARGUMENTS.PROD_DES#', '#ARGUMENTS.PROD_COLOR#', '#ARGUMENTS.INSTOCK#' )
</cfquery> </cffunction> </cfcomponent> Text

Use CFTRY/CFCATCH to catch the error and get the detailed reason why:

What you describe is that you are able to read from the database but not to
write into it . It looks to me that it is a Server permissions problem (very
common). You have to enable read and write permissions to "anyone". The way to
do this will depend on what kind of access you have to the server. If it is a
rented (shared) space ,the hosting company will usually provide a control panel
that control Folder/File permissions.