Sunday, February 19, 2012

Complete idiot in dire need of help. :)

Alright, I've been trying to get this working for for-friggin ever, but it doesn't seem to work... :(

Here's the script:

<%
Set Text = request.form ("textfield")
Text = escape(Text)
Text = Replace(Text,"%0D%0A","<br>")
Text = unescape(Text)

Dim DB
Set DB = Server.CreateObject ("ADODB.Connection")
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + "DB\example.mdb")
Dim RS
Set RS = Server.CreateObject ("ADODB.Recordset")
RS.Open "startpage", DB, adOpenDynamic
RS.AddNew
RS ("content") = Text
RS.Update
%>

And I get:
ADODB.Recordset- Error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

H:\Web Server\htdocs\CCI\forms2.asp, line 14

Guessing this is because i am, as the subject suggests, a complete idiot. :P

So perhaps someone here would find it in their heart to enlighten me?On closer inspection, that probably shouldve been posted in the ASP forum, huh?

No comments:

Post a Comment