Delete and Update are not working

[scottd431]

We are developing in Dreamweaver MX on a Win2K system. The Coldfusion MX 6.1 resides on a RH Linux 8.0 server and database is Informix SE 7.25. The DSN is working and we can do a query and it works. But we have tried both update and delete and we can not get it to work. What could cause this? Thanks

 

[TruthInSatire]

errors? code?

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[NorthStarDA]

sounds like the username you are using in the DSN does not have update and delete privileges for that table? i dont know a think about Informix, this would usually be the first thing i check. are you getting any errors anywhere?

 

[scottd431]

The following is the error we are receiving

SQL delete from ma_clients where _numebr = 808
DATASOURCE oms
VENDORERRORCODE -79782
SQLSTATE IX000

 

[scottd431]

sorry I had a typo posting that it should be ma_number = 808

 

[NorthStarDA]

1: have you checked permissions for the user you are using?

2: can you copy the full error page into the forum? there should be more than that, including the stack trace.

 

[scottd431]

thanks so much for the assistance so far. Is this what you were referring too?
CUSTOMER UPDATE FORM



Customer Name

Customer Address

Customer City/State

Customer Zip Code

Customer Phone#






Error Occurred While Processing Request
Error Executing Database Query.
Method can be called only once.

The error occurred in /var/

http://www/html/del_call.cfm:

line 36

34 : <cfquery datasource="oms">
35 : delete from ma_clients
36 : where c_number = #upcall1.c_number#
37 : </cfquery>
38 : </html>



--------------------------------------------------------------------------------

SQL delete from ma_clients where c_number = 808
DATASOURCE oms
VENDORERRORCODE -79782
SQLSTATE IX000

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address 192.168.42.133
Referrer

http://192.168.42.132/omnicall0.cfm

Date/Time 05-Feb-04 04:41 AM

Stack Trace (click to expand)
at cfdel_call2ecfm781373357.runPage(/var/

http://www/html/del_call.cfm:36)

at cfdel_call2ecfm781373357.runPage(/var/

http://www/html/del_call.cfm:36)

java.sql.SQLException: Method can be called only once.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxStatement.getUpdateCount(IfxStatement.java:684)
at coldfusion.server.j2ee.sql.JRunStatement.getUpdateCount(JRunStatement.java:231)
at coldfusion.sql.Executive.getRowSet(Executive.java:482)
at coldfusion.sql.Executive.executeQuery(Executive.java:974)
at coldfusion.sql.Executive.executeQuery(Executive.java:886)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfdel_call2ecfm781373357.runPage(/var/

http://www/html/del_call.cfm:36)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)