The sql database has an ntext (16) field which contains "information" and is used as a free form turnover log. When I bring this data into an ASP page the "information" gets truncated.
I have tried getchunk, however all formatting on the field is lost.
I have tried putting the field at the end of my query - no change.
I have tried querying the data as a separate sqlrs connection - no change.
I have tried using substring to break it down, the first substring works, however I get errors on the second (Expression result length exceeds the maximum. 8000 max, 12000 found).
I also tried to use substring in sql query anaylzer - and only get the first ~4180 characters.
Is there a way to split this field into multiple nvarchar fields in my temporary table in sql and then concatenate back together in asp report???
The data is truncated when using
response.write("<td width='100%' colspan='4'>" & strIssue & " </td>")
to write dat out to screen.
The data is entered via a vb application which shows everything on the screen and also in the canned VB reports. Problem occurs with the asp page.
Its just working fine in my machine..check the data after storing in the database.
conn.open"Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=joy"
rs.open("select * from gogo"),conn