Hvorfor kommer denne fejl under oprettelse
strSQL = "Insert into forum_topics ("strSQL = strSQL & "CAT_ID, "
strSQL = strSQL & "FORUM_ID, "
strSQL = strSQL & "T_STATUS, "
strSQL = strSQL & "T_MAIL, "
strSQL = strSQL & "T_SUBJECT, "
strSQL = strSQL & "T_MESSAGE, "
strSQL = strSQL & "T_AUTHOR, "
strSQL = strSQL & "T_REPLIES, "
strSQL = strSQL & "T_UREPLIES, "
strSQL = strSQL & "T_VIEW_COUNT, "
strSQL = strSQL & "T_LAST_POST, "
strSQL = strSQL & "T_DATE, "
strSQL = strSQL & "T_LAST_POSTER, "
strSQL = strSQL & "T_IP, "
strSQL = strSQL & "T_LAST_POST_AUTHOR, "
strSQL = strSQL & "T_LAST_POST_REPLY_ID, "
strSQL = strSQL & "T_ARCHIVE_FLAG, "
strSQL = strSQL & "T_LAST_EDIT, "
strSQL = strSQL & "T_STICKY, "
strSQL = strSQL & "T_SIG, "
strSQL = strSQL & "T_ISEVENT, "
strSQL = strSQL & "T_ISPOLL, "
strSQL = strSQL & "T_POLLSTATUS) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'"&Request.QueryString("CAT_ID")&"', "
strSQL = strSQL & "'"&Request.QueryString("FORUM_ID")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_STATUS")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_MAIL")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_SUBJECT")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_MESSAGE")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_AUTHOR")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_REPLIES")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_UREPLIES")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_VIEW_COUNT")&"', "
strSQL = strSQL & "'"&samlet&"', "
strSQL = strSQL & "'"&samlet&"', "
strSQL = strSQL & "'"&Request.QueryString("T_AUTHOR")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_IP")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_AUTHOR")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_LAST_POST_REPLY_ID")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_ARCHIVE_FLAG")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_LAST_EDIT")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_STICKY")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_SIG")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_ISEVENT")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_ISPOLL")&"', "
strSQL = strSQL & "'"&Request.QueryString("T_POLLSTATUS")&"')"
Conn.Execute(strSQL)
Jeg får følgende fejl
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Data truncated for column 'T_LAST_POST_REPLY_ID' at row 1
/mobil/opret.asp, line 119