Are any of the tables involved on your query linked, or read-only? That's an error I will often get directly in Access if I try to run an update on a table using a readonly table (even if the fields being updated are in a fully-updatable table- if they're getting the data from a non-updateable table, it fails for some reason). Other than that, all I can say is that the Access drivers that come with CF MX absolutely suck :( They have been nothing but a hassle for us, and we're now trying to move all our DB's to oracle.
Kevin > -----Original Message----- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 3:30 PM > To: CF-Talk > Subject: RE: Insert and update ? For new CF server > > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
