OK, I know what this is. The ID will have a data type of 'uniqueidentifier', probably with a default value of newid(). SQL Server will generate this for you on...

So the question is: "What generates the SubmissionID code?"

If it's a SQL Server IDENTITY field, you can try the INSERT statement I gave you, but without the SubmissionID, ie

Try inserting the row without the CONTENT and SELECTED fields first. If it works, we'll move on to CONTENT.

INSERT INTO mytable (SubmissionID, StoryID, SubscriberID, DateSubmitted)

VALUES (p1, p2 ,p3 ,GetDate())

and...

The very existence of an 'insert row' option makes it difficult to suggest that this is 'wrong'

You are using tools that I have...

No problem. Regarding the syntax / access violation problem, can you post the SQL command that you issued?

OK - don't do it, you are right!! It will not fix anything, I was merely trying to help you troubleshoot exactly where the error was being generated. But that's...

In my mind, there is a logical separation between the function of the JOIN clause (joining tables together) and the WHERE clause (filtering the data that is returned). Shovelling everything...

I don't quite understand what you want. Can you post the SP, some sample data and desired results?

Try commenting out line 102 and replace it with

response.write("EXEC InsertNextPage @StoryID='" & submission.Fields("StoryID") & "', @SubscriberID='" & submission.Fields("SubscriberID") & "', @Content='" & Cleanse(submission.Fields("Content")) & "'")

This should write a T-SQL...

Please post the declarations and instantiation of the conn object.

I guess the good thing about using views is that they are always up-to-date. You can just grab the data out of their database whenever you want (subject to load...

If the data that is coming out of the examination system contains rubbish as a result of bad design, that should not be your problem. You will end up building...

This sounds like a reply - but to what message?

Great - I like stories with happy endings

Create a table that contains just numbers - 0, 1, 2, 3, ..., 1000 say.

Then do a CROSS JOIN to this table from your label data source, where newtable.num < number of...