*haster*: "String or binary data would be truncated. "
Jeg er ved at tilrettet noget kode, jeg ikke selv har lavet :(Jeg troede jeg havde løst denne fejl, men nu er den kommet igen .. hjæææææææælp!
Fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
/EditTask.asp, line 168
KODE:
If check_vist = 1 then
SQLstmt = "UPDATE opgave SET Prioritet = '" & Tekst & "',deadline = '" & deadline & "',Status = '" & Status & "',Slutdato = '" & Slutdato & "',Losning = '" & Losning & "',Afsluttet = '" & check_afsluttet & "' WHERE ID = '" & request("ID") & "' "
'SQLstmt = SQLstmt & "VALUES ('" & Request.Form("ny_prioritet") & "','" & Request.Form("ny_deadline") & "','" & Request.Form("ny_status") & "','" & Request.Form("Slutdato") & "','" & Request.Form("ny_losning") & "','" & Request.Form("check_afsluttet") & "')"
dbadhoc.Execute (SQLstmt)
dbadhoc.Close
Set dbadhoc = nothing
Set SQLstmt = nothing
SQL = "SELECT * from opgave WHERE ID = '" & request("ID") & "' "
set rs = Conn.Execute(sql)
strCreateNew="Insert into Knowledgebase (Betegnelse,Kategori,Problem,Losning,Vis_intranet,dato)VALUES ('" & rs("Betegnelse") & "','" & rs("Kategori") & "','" & rs("problem") & "','" & rs("Losning") & "','" & 1 & "','" & date+time & "')"
DBCMD.Execute strCreateNew <-- linie 168
DBCMD.Close
set DBCMD = nothing
rs.Close
Set rs = Nothing
Set SQL = Nothing
response.redirect "start_adm.asp"
