| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
asp-db problem
hey i'm using vb for this application. When i try to request "terug" he says:
ADODB.Recordset (0x800A0CB3) Bijwerken wordt door de huidige verzameling records niet ondersteund. Dit kan een beperking zijn van de voorziening of van het geselecteerde type vergrendeling. /asp-gip10/boeking2.asp, line 17 now i thing i must add a cursortype or locktype but i don't know where to put it in my code. code: <%@ LANGUAGE="VBSCRIPT" %> <% Option Explicit Dim strKlantID Dim cnDB Dim strConnstring ' Verbinding strConnstring= "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("c&s.mdb") set cnDB = Server.CreateObject("ADODB.Connection") cnDB.open strConnstring, 2, 2 SELECT CASE Request("cmdKeuze") CASE "Terug" Dim rstKlanten1 set rstKlanten1 = cnDB.execute("SELECT * FROM qryKlanten") rstKlanten1.delete Response.Redirect "Klanttoevoeg.asp" CASE "Verder" %> I try to delete the first record of my database (query) but i doesn't work Someone a solution? Thanks |
|
#2
|
||||
|
||||
|
Try changing you code to this
Code:
cnDB.open strConnstring, 3, 3 |
![]() |
| Viewing: ASP Free Forums > Programming > Code Bank > asp-db problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|