I'd suggest using the ODBC socket instead of the JDBC driver to see if it makes a difference. The pure JDBC driver should give better performance but the ODBC socket might work better!!
WG -----Original Message----- From: Jim Kraft [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 15:41 To: CF-Talk Subject: RE: Insert and update ? For new CF server On Friday 06 Jun 2003 14:59 pm, Jim Kraft wrote: > SQL insert into 2003QR (NAME,PASSWORD) values ( (param 1) , (param 2) ) >This table name my be illegal (doesn't start with a char. >I've seen this form MS SQL server when there is a reserved word or something >like that in the query. This does not seem to be the issue as there is another page that uses a table with a char. It seems to be in the phrase "Operation must use an updateable query." That is what I do not understand as it has always worked as an updateable query. Thanks 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\Calendar\Calendar.cfm: line 8 6 : (TitleofEvent, Organization, ContactName, Phone, Email, Instructor, TypeofEvent, Topic, ClassStarts, ClassEnds, TimeofEvent, CityofEvent, CountyofEvent, Web, Description) 7 : VALUES ('#TitleofEvent#', '#Organization#', '#ContactName#', '#Phone#', '#Email#', '#Instructor#', '#TypeofEvent#', '#Topic#', '#ClassStarts#', '#ClassEnds#', '#TimeofEvent#', '#CityofEvent#', '#CountyofEvent#', '#Web#', '#Description#') 8 : </CFQUERY> 9 : 10 : <CFELSEIF #ParameterExists(EditArtist)# IS "Yes"> ---------------------------------------------------------------------------- ---- SQL INSERT INTO calendar (TitleofEvent, Organization, ContactName, Phone, Email, Instructor, TypeofEvent, Topic, ClassStarts, ClassEnds, TimeofEvent, CityofEvent, CountyofEvent, Web, Description) VALUES ('x', 'x', 'x', 'x', 'x', 'x', 'x', 'Managing-A-Business', '12/22/2003', 'x', 'x', 'x', 'x', 'x', 'xx') DATASOURCE wsbdc VENDORERRORCODE -3035 SQLSTATE HY000 -- Tom C "Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
