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