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...
if (NOT WA_AppBuilderRecordset.EOF) then Session(WA_sessionName)
If I comment them out, the extension works normally without an error. Any idea why these 3 lines would choke on a long entry?