|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
3219 Errors |
|
From: |
Paul Distant |
|
Date: |
8/15/2000 1:34:49 PM |
|
IP: |
212.43.182.2 |
Hi
Iv created a script to add a new record to my SQL Server V7 DBMS. The problem is that users of my site keep getting the following error message whent they try to save their details. If I try then the script works fine.
Heres the error message:
ERROR NUMBER: 3219
SOURCE: ADODB.Recordset
DESCRIPTION: The operation requested by the application is not allowed in
this context.
The code that adds the user details to the database is:
sqlInsert = "SELECT * FROM XYZTable "
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sqlInsert,sktconn, adOpenKeySet, adLockPessimistic, adCmdText
with rs
.Source = sqlInsert
.LockType = adLockPessimistic
.CursorType = adOpenDynamic
.ActiveConnection= sktconn
.Open
On Error Resume Next
.AddNew
.Fields("stud_id") = Cint(Session("StudentID"))
.Fields("skill_id")= Cint(Request.Form("skill_id"))
.Fields("post_level") = CInt(Request.Form("post_level"))
.Fields("post_skillevidence") = Trim(Request.Form("post_skillevidence"))
.Fields("post_this_complete") = 1
.Fields("post_post_date") = FormatDateTime(Now(),VBGeneralDate)
.update
end with
rs.Close
Set rs = Nothing
I have included the adovbs.inc file for the constants.
Does anyone have any ideas on how I can get rid if this PEST of an error message.
Cheers,
Distie |
Follow Up - Re: 3219 Errors - cm 8/16/2000 2:57:55 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
