If you do not use cfinsert and cfupdate, what tags are there to make it work. Also in the documentation it says these tags are depreciated. Does anyone know what that means. Progress :-)
I try do not use CFINSERT or CFUPDATE. -----Original Message----- From: Jim Kraft [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 9:00 AM To: CF-Talk Subject: Insert and update ? For new CF server I have been using cold Fusion 3.X for years and just upgraded to a server with the latest version. All of my queries worked fine on the old version but now I get this error message on my insert. Is there something I need to do with the code or is it in the server. Thanks for any assistance. 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 D:\wwwroot\Kraft\Qtr Report 2003\InsertQR2003.cfm: line 14 12 : <body bgcolor="FFFFFF"> 13 : <img src="../images2/banner.JPG" width="700" height="114"> 14 : <CFINSERT DATASOURCE="QtrReport2003" TableName="2003QR"> 15 : 16 : <CFQUERY NAME="GetEnteredRecordID" DATASOURCE="QtrReport2003"> ---------------------------------------------------------------------------- ---- SQL insert into 2003QR (NAME,PASSWORD) values ( (param 1) , (param 2) ) DATASOURCE QtrReport2003 VENDORERRORCODE -3035 SQLSTATE HY000 It also will run the update pages it gives the following error message. 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 D:\wwwroot\Kraft\Qtr Report 2003\UpdateQR2003.cfm: line 14 12 : <body bgcolor="FFFFFF"> 13 : <img src="../images2/banner.JPG" width="700" height="114"> 14 : <CFUpdate DATASOURCE="QtrReport2003" TableName="2003QR"> 15 : 16 : <CFQUERY NAME="GetUpdate" DATASOURCE="QtrReport2003"> ---------------------------------------------------------------------------- ---- SQL update 2003QR set ACTUALHOURS1= (param 1) ,BRANDING1= (param 2) ,NOTINBUS1= (param DATASOURCE QtrReport2003 VENDORERRORCODE -3035 SQLSTATE HY000 Jim Kraft, Director Region 8 SBDC 33 South 3rd St. Richmond, IN 47374 765-962-2887 fax 765-966-0882 [EMAIL PROTECTED] http://www.sbdc1.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
