Re: Jeffrey Houser Yeah, that's what I thought (CF6/7 jump). I had originally written the code for CF5. But the old host said they were running CF6 when the server crashed, so if they're telling the truth I guess that's not the problem. I ran the offending code through a CF7 code checker and it said everything was fine. (and the check's in the mail, she said she was 18, etc etc) What's the big difference with the "MX" stuff?
Re: Claude S. Here's the error msge. What confuses me is all the (param 1) (param 2) stuff. If it would put the actual value in there it would be so much more helpful. Then I'd have a clue. ------------------------------------------------------- Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred in (removed part of this for fear of hackers) salvageh\admin\editcar_action.cfm: line 15 13 : 14 : <!--- ***** Actual Update Happens Here ***** ---> 15 : <CFupdate datasource="recursalv" tablename="vehicles"> 16 : 17 : <!--- ************************************************* ---> -------------------------------------------------------------------------------- SQL update vehicles set BLURB= (param 1) ,WHEELTYPE= (param 2) ,MFR= (param 3) ,CONV= (param 4) ,DOORS= (param 5) ,PAINTJOB= (param 6) ,AC= (param 7) ,GLASS= (param 8) ,PAINTCOLOR= (param 9) ,CUSTOM= (param 10) ,EBAY_URL= (param 11) ,INT_COND= (param 12) ,DATE_ADD= (param 13) ,NORUN= (param 14) ,BODYSTYLE= (param 15) ,OWNERID= (param 16) ,DISPLACE= (param 17) ,PB= (param 18) ,PW= (param 19) ,TIRES= (param 20) ,PD= (param 21) ,DESCRIPTION= (param 22) ,MODEL= (param 23) ,PAINTCOND= (param 24) ,VIN= (param 25) ,PS= (param 26) ,YEAR= (param 27) ,WEB= (param 28) ,INT_COLOR= (param 29) ,PRICE= (param 30) ,TRANS= (param 31) ,CYL= (param 32) ,FUEL= (param 33) ,TITLE= (param 34) ,EBAY= (param 35) ,TOP= (param 36) ,MILEAGE= (param 37) ,DATE_MOD= (param 38) where ID= (param 39) DATASOURCE recursalv VENDORERRORCODE -3503 SQLSTATE 42000 Resources: 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.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 3.1) Remote Address 68.62.251.206 Referrer http://www.salvagehunter.com/admin/editcar_check.cfm Date/Time 18-Oct-06 03:50 AM Stack Trace (click to expand) at cfeditcar_action2ecfm1441267827.runPage(D:\inetpub\wwwroot\recursiv\salvageh\admin\editcar_action.cfm:15) at cfeditcar_action2ecfm1441267827.runPage(D:\inetpub\wwwroot\recursiv\salvageh\admin\editcar_action.cfm:15) java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source) at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source) at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source) at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source) at macromedia.sequelink.ssp.Chain.decode(Unknown Source) at macromedia.sequelink.ssp.Chain.send(Unknown Source) at macromedia.sequelink.ctxt.stmt.StatementContext.execute(Unknown Source) at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source) at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.slbase.BasePreparedStatement.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:87) at coldfusion.sql.Executive.executeQuery(Executive.java:722) at coldfusion.sql.Executive.executeQuery(Executive.java:652) at coldfusion.sql.Executive.executeQuery(Executive.java:613) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.InsertTag.doStartTag(InsertTag.java:639) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925) at cfeditcar_action2ecfm1441267827.runPage(D:\inetpub\wwwroot\recursiv\salvageh\admin\editcar_action.cfm:15) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:209) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) -------------------------------------------------------------------------- May not get to respond until the weekend. That 9-5 thing keeps tying up all my time. (which is why I haven't been able to sit down and inspect this properly in the first place) Thanks All Indy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2585 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
