Home | Advertising Info6 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Friday, March 29, 2024  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - Database Issues
 PowerASP Code Help Area : Classic ASP - Database Issues
Subject Info: Peculiar database problem A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
Djadja Zloj
Newbie
Newbie
Avatar

Joined: June/03/2005
Location: Sweden
Online Status: Offline
Info: 5
Added: June/08/2005 at 9:46am | IP Logged Quote Djadja Zloj

I got  two maps with the exact same files.

Except the path to the database.

Everything works fine until i shall update.

Then one works the other dont.

 

I get error msg "Operation must use an updateable "

 

My code is something like this:

 

Set MyConn = Server.CreateObject("ADODB.Connection")
 MyConn.Mode = 3
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";"

MyConn.open strConn

 

SQL_sjreg="UPDATE SJREGIS SET SJREGIS.AVR_OMR = '" & request.form("AVR_OMR") & "', SJREGIS.SJÖNAMN = '" & request.form("SJÖNAMN") & "', SJREGIS.EKOBL = " & nulla(request.form("EKOBL")) & ", SJREGIS.FLODOMRÅDE = '" & request.form("FLODOMRÅDE") & "', "
SQL_sjreg=SQL_sjreg & "SJREGIS.MAXDJUP = " & nulla(request.form("MAXDJUP")) & ", SJREGIS.MEDELDJUP = " & nulla(request.form("MEDELDJUP")) & ", SJREGIS.AVROMR = " & nulla(request.form("AVROMR")) & ", SJREGIS.AVRTAL = " & nulla(request.form("AVRTAL")) & ", "
SQL_sjreg=SQL_sjreg & "SJREGIS.MEDELQ = " & nulla(request.form("MEDELQ")) & ", SJREGIS.ANM = '" & request.form("ANM") & "', SJREGIS.STATUS = '" & request.form("STATUS") & "', SJREGIS.OMSTID = " & nulla(request.form("OMSTID")) & ", "
SQL_sjreg=SQL_sjreg & "SJREGIS.VOLYM = " & nulla(request.form("VOLYM")) & ", SJREGIS.SJÖYTA = " & nulla(request.form("SJÖYTA")) & ", SJREGIS.STRANDLÄNGD = " & nulla(request.form("STRANDLÄNGD")) & ", SJREGIS.SMHI_BET = '" & request.form("SMHI_BET") & "', "
SQL_sjreg=SQL_sjreg & "SJREGIS.KLASS = '" & request.form("KLASS") & "', SJREGIS.FLIKIGHETSTAL = " & nulla(request.form("FLIKIGHETSTAL")) & " "
SQL_sjreg=SQL_sjreg & "WHERE (((SJREGIS.sjoID)='" & sjoID & "'));"

 

MyConn.Execute SQL_sjreg,,128

MyConn.Close
Set MyConn = Nothing

 



__________________
BR D.Z.
Back to Top View Djadja Zloj's Profile Search for other info by Djadja Zloj
 
Djadja Zloj
Newbie
Newbie
Avatar

Joined: June/03/2005
Location: Sweden
Online Status: Offline
Info: 5
Added: June/08/2005 at 9:47am | IP Logged Quote Djadja Zloj

Operation must use an updateable query.

that is



__________________
BR D.Z.
Back to Top View Djadja Zloj's Profile Search for other info by Djadja Zloj
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: June/08/2005 at 3:47pm | IP Logged Quote cwilliams

google the error message.. the answer is everywhere

__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
firas_TheGeek
Newbie
Newbie
Avatar

Joined: May/27/2006
Location: Oman
Online Status: Offline
Info: 28
Added: May/27/2006 at 9:43am | IP Logged Quote firas_TheGeek

this is a very common error

the solution is

MyConn.Execute(SQL_sjreg).LockType = 3

Hope this helps

tell me what happens with u

 

Best Regards



__________________
Firas S Assaad (TheGeek)
firas489@gmail.com
0096892166434
http://firas-thegeek.blogspot.com
Back to Top View firas_TheGeek's Profile Search for other info by firas_TheGeek Visit firas_TheGeek's Homepage
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2024 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com