I think if you take a 2nd look at the depreciated list for MX you will see that that cfupdate tag is not depreciated, rather only one or two of its attributes.
I use CFupdate on every project I do. I have very very few problems with it. (Other then the MX requiring the Primary key field to be in the formfields. Please MM fix this soon) Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: Jim Kraft [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:09 PM To: CF-Talk Subject: RE: Insert and update ? For new CF server 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
