thank you so much! I will try that out now.

Hi

ok thanks for letting me know, the page I mentioned is the page I initially posted about pagesubmissions.asp that had the error in. So I will have to try and...

hi

its a varchar  and allows for 5000 characters

my concern is that the story page has things like "  " and '   '  plus other things and also has paragraph breaks...

Thank you so much!

I have now managed to add the basic record for the story submission.

Just need to work out now how to add in the long content...

hi

so do you think the following statement will work:

INSERT INTO FamousFacesSubmissions ({4259348C-32B9-4153-BDC3-592E0F27C10F}, {F421AC0C-FD3E-4D57-99FB-6177B1840857}, GetDate())

Where the first one is storyID, second is subscriberID (know these are real) and DateSubmitted...

Hi

this is the example requestID one I previously tried to use in the SubscriberID field.

{3361F5F7-E284-4CF1-8451-8A39CB381806}

These types of codes seem to be used in storyID, subscriberID etc type fields

hi

sorry for the delay in getting back to you.

I have been having problems with submissionID field

I dont have any examples of how this should look / be constructed etc, all...

Hi

the table fields are as follows:

SubmissionID - PK - 16

StoryID - FK - 16

SubscriberID -...

Hi

I didnt do it like that, their hosting company has a web based enterprise manager and when viewing the relevant table there was the option to insert a new row,...

hi

thanks for confirming my thoughts regarding that.

I appreciate all your help and hopefully someone might be able to help spot the error.

I think a testing environment would be a good...

hi

sorry for the probably dumb question, but will that just display test messages on the page with the results of trying that query to then try and find the problem...

hi

Is this the part you need? (The last paragraph of the code being line 102)

Thanks for your help.

Dim submission

 Set submission = Server.CreateObject("ADODB.Recordset")

 submission.Open "SELECT * FROM FamousFacesSubmissions WHERE SubmissionID='" & Request.Form("SubmissionCB")...