Truncated error

I have a text fileld that will allow for long entries... the field is a varchar(MAX) SQL Server 2008. But, if the entry is more than approximately 4K or 5K, I get the SQL error that "String or binary data would be truncated"... but strangely enough, the entire thing is written to the database. After some investigating of the error line, the problem is with these three lines...

WA_AppBuilderRecordset.Open()
if (NOT WA_AppBuilderRecordset.EOF) then Session(WA_sessionName)
=WA_AppBuilderRecordset.Fields.Item(WA_indexField).Value
WA_AppBuilderRecordset.Close()

If I comment them out, the extension works normally without an error. Any idea why these 3 lines would choke on a long entry?

Those three lines are looking up the record that was just created to get the ID and store it in a session variable.

so it sounds like the data being truncated is the binary field in the lookup recordset.

it may work to edit these three line:
WA_AppBuilderRecordset.Open()
if (NOT WA_AppBuilderRecordset.EOF) then Session(WA_sessionName)
=WA_AppBuilderRecordset.Fields.Item(WA_indexField) .Value
WA_AppBuilderRecordset.Close()

to:
On Error resume Next
WA_AppBuilderRecordset.Open()
if (NOT WA_AppBuilderRecordset.EOF) then Session(WA_sessionName)
=WA_AppBuilderRecordset.Fields.Item(WA_indexField) .Value
WA_AppBuilderRecordset.Close()


but i dont think the session variable would be created doing this.

I think that would have the same results as just commenting out the lines. Either way, for this form, the session variable isn't needed anyway, and I don't usually have forms that submit ridiculously large amount of information.

Thanks,

Brian

OK, if you dont need the session in this case, then commenting those lines or setting the On Error Resume Next should do the trick for you.