Jeg har problemer med at opdater et felt i min ms sql database
Når jeg prøver at opdater et felt i min tabel får jeg følgende:Cannot create a row of size 8222 which is greater than the allowable maximum of 8060.
Feltet jeg vil opdatere er sat til nvarchar med en længde på 4000. Den tekste jeg prøver at indsætte i feltet er følgende:
<br> </TD>
<TD width=15 background="Data/Pics/2/Design/folder_54.gif"> </TD>
</tr>
<tr>
<TD vAlign=bottom background=Data/Pics/2/Design/folder_28.gif width="8"><IMG
height=14 src="Data/Pics/2/Design/folder_46.gif" width=16></TD>
<TD width=15 background="Data/Pics/2/Design/folder_54.gif"> </TD>
</tr>
<tr>
<TD width="8" height="13"><IMG height=16 src="Data/Pics/2/Design/folder_55.gif"
width=16></TD>
<TD background=Data/Pics/2/Design/folder_56.gif width="28" height="13"> </TD>
<TD background=Data/Pics/2/Design/folder_56.gif width="77" height="16"> </TD>
<TD background=Data/Pics/2/Design/folder_62.gif width="41" height="16"><IMG height=16
src="Data/Pics/2/Design/folder_58.gif" width=16></TD>
<TD background=Data/Pics/2/Design/folder_62.gif colSpan=4 width="174" height="16"><IMG
height=16 src="Data/Pics/2/Design/folder_62.gif" width=5></TD>
<TD width="15" height="16"><IMG height=16 src="Data/Pics/2/Design/folder_63.gif"
width=14></TD>
</tr>
</table>
Jeg opdater vha. følgende:
sql= "SELECT DesignBund FROM System WHERE SystemID = 2"
Conn.execute("UPDATE System SET DesignBund = '" & request.form("Tekst") & "' Where SystemID = 2")
