Object required error in page

[missa]

hi

I have an error in my page, the error is:

Microsoft VBScript runtime error '800a01a8'
Object required: ''
/admin/PageSubmissions.asp, line 102

Line 102 is as follows:
conn.Execute("EXEC InsertNextPage @StoryID='" & Request.Form("StoryID") & "', @SubscriberID='" & Request.Form("SubmitterID") & "', @Content='" & Cleanse(Request.Form("SubmittedPage")) & "'")

I have been struggling with this error for a couple of days now and cant seem to fix it...

I tried adding the story directly into the database table (SQL Server table) but this resulted in another error Error -2147217900 - Syntax error or access violation

If someone could possibly help me try and solve this error, it would be much appreciated!

I can provide any further information, you might need.

Thank you in advance

Missa

[antares686]

Try creating a variable setting the vairbale equal to your string and passing in the variable to the execute. Have seen builing a string throw issues before.

Dim strSQL

strSQL = "EXEC InsertNextPage @StoryID='" & Request.Form("StoryID") & "', @SubscriberID='" & Request.Form("SubmitterID") & "', @Content='" & Cleanse(Request.Form("SubmittedPage")) & "'"

conn.Execute strSQL

If it fails then try showing the value of strSQL to make sure it looks correct.