Please, call me at 216-288-1768. I have a job for a Cold Fusion developer in Ohio and developer can work remotely, complete the job and download remotely. A check will be sent to the person...
Job: 1. development 2. To fix a hosted website having db problem such as: Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The Error Occurred in C:\Websites\lutherMBA\admin\qry_editpagesubmit.cfm: line 7 Called from C:\Websites\lutherMBA\admin\index.cfm: line 63 Called from C:\Websites\lutherMBA\admin\index.cfm: line 151 Called from C:\Websites\lutherMBA\admin\qry_editpagesubmit.cfm: line 7 Called from C:\Websites\lutherMBA\admin\index.cfm: line 63 Called from C:\Websites\lutherMBA\admin\index.cfm: line 151 5 : 6 : <div align="center" class="header">Page Content Updated Successfully</div> 7 : <br> -------------------------------------------------------------------------------- SQL update Pages set ACTION= (param 1) ,CONTENT= (param 2) where FPID= (param 3) DATASOURCE mbadata VENDORERRORCODE -3035 SQLSTATE HY000 Please Try The Following: Check the CFML Reference Manual 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.1; SV1; CoxIE55; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) Remote Address 24.136.46.29 Referer http://www.lutherinfo.com/admin/index.cfm?Action=EditPage&FPID=12 Date/Time 13-Mar-07 10:14 AM Stack Trace (click to expand) at cfqry_editpagesubmit2ecfm604994356.runPage(C:\Websites\lutherMBA\admin\qry_editpagesubmit.cfm:7) at cfindex2ecfm1064836313._factor0(C:\Websites\lutherMBA\admin\index.cfm:63) at cfindex2ecfm1064836313.runPage(C:\Websites\lutherMBA\admin\index.cfm:151) at cfqry_editpagesubmit2ecfm604994356.runPage(C:\Websites\lutherMBA\admin\qry_editpagesubmit.cfm:7) at cfindex2ecfm1064836313._factor0(C:\Websites\lutherMBA\admin\index.cfm:63) at cfindex2ecfm1064836313.runPage(C:\Websites\lutherMBA\admin\index.cfm:151) java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. at com.merant.sequelink.ssp.Diagnostic.toSQLException(Unknown Source) at com.merant.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source) at com.merant.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source) at com.merant.sequelink.ssp.Chain.decodeBody(Unknown Source) at com.merant.sequelink.ssp.Chain.decode(Unknown Source) at com.merant.sequelink.ssp.Chain.send(Unknown Source) at com.merant.sequelink.ctxt.stmt.StatementContext.send(Unknown Source) at com.merant.sequelink.ctxt.stmt.StmtCtxtState._getDescribeInfo(Unknown Source) at com.merant.sequelink.ctxt.stmt.OpenStmtCtxt.getDescribeInfo(Unknown Source) at com.merant.sequelink.ctxt.stmt.StatementContext.getDescribeInfo(Unknown Source) at com.merant.sequelink.ctxt.stmt.StmtCtxtState._execute(Unknown Source) at com.merant.sequelink.ctxt.stmt.OpenStmtCtxt.execute(Unknown Source) at com.merant.sequelink.ctxt.stmt.StatementContext.execute(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkStatement._execute(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkStatement.execute(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkPreparedStatement.execute(Unknown Source) at jrun.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:134) at coldfusion.sql.Executive.executeQuery(Unknown Source) at coldfusion.sql.Executive.executeQuery(Unknown Source) at coldfusion.sql.SqlImpl.execute(Unknown Source) at coldfusion.tagext.sql.InsertTag.doStartTag(Unknown Source) at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source) at cfqry_editpagesubmit2ecfm604994356.runPage(C:\Websites\lutherMBA\admin\qry_editpagesubmit.cfm:7) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source) at cfindex2ecfm1064836313._factor0(C:\Websites\lutherMBA\admin\index.cfm:63) at cfindex2ecfm1064836313.runPage(C:\Websites\lutherMBA\admin\index.cfm:151) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) 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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Jobs/message.cfm/messageid:5070 Subscription: http://www.houseoffusion.com/groups/CF-Jobs/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.13
