I saw another guy with this same problem but his solution did not solve my issue.
My environment is ASP/Vbscript
When doing an update I get
Error Type:
Provider (0x80020005)
Type mismatch.
/damnblog/blogedit.asp, line 22
Line 22:
rs("blog_title") = request.form("blog_title")
rs.fields.item("blog_body").value = request.form("fckeditor1")
rs("blog_date") = request.form("blog_date")
rs.update
The other post on this topic said that by adding the "field.item" his problem was solved. I can add a new record no problem.
Here's the initialization code:
Dim oFCKeditor
Set oFCKeditor = New FCKeditor
oFCKeditor.BasePath = sBasePath
oFCKeditor.Value = rs.fields.item("blog_body").value
oFCKeditor.Create "FCKeditor1"
any help would be greatly appreciated!
My environment is ASP/Vbscript
When doing an update I get
Error Type:
Provider (0x80020005)
Type mismatch.
/damnblog/blogedit.asp, line 22
Line 22:
rs("blog_title") = request.form("blog_title")
rs.fields.item("blog_body").value = request.form("fckeditor1")
rs("blog_date") = request.form("blog_date")
rs.update
The other post on this topic said that by adding the "field.item" his problem was solved. I can add a new record no problem.
Here's the initialization code:
Dim oFCKeditor
Set oFCKeditor = New FCKeditor
oFCKeditor.BasePath = sBasePath
oFCKeditor.Value = rs.fields.item("blog_body").value
oFCKeditor.Create "FCKeditor1"
any help would be greatly appreciated!
Re: Updating Access Memo Field - data type mismatch
I just decided to do a SQL Update statement and all is well....
Love the FCKEditor.
http://www.damnineedajob.com