indsætte data fejler
Hvorfor kan jeg ikke indsætte dette i min tabel?TABLE:
strSQL = "CREATE TABLE members ("
strSQL = strSQL & "[id] int identity(1,1),"
strSQL = strSQL & " ip varchar(20),"
strSQL = strSQL & " navn varchar(100),"
strSQL = strSQL & " brugernavn varchar(30),"
strSQL = strSQL & " password varchar(100),"
strSQL = strSQL & " hjemmeside varchar(255),"
strSQL = strSQL & " email varchar(255),"
strSQL = strSQL & " beskrivelse text,"
strSQL = strSQL & " foedselsdato datetime,"
strSQL = strSQL & " [status] varchar(8),"
strSQL = strSQL & " dato varchar(255),"
strSQL = strSQL & " nyhedsbrev varchar(3),"
strSQL = strSQL & " [by] varchar(255),"
strSQL = strSQL & " oprettet datetime,"
strSQL = strSQL & " adminstat varchar(1),"
strSQL = strSQL & " musicchart_mail varchar(30)"
strSQL = strSQL & " primary key ([id]))"
Conn.Execute(strSQL)
DATA:
strSQL = "Insert into members("
strSQL = strSQL & "ip, "
strSQL = strSQL & "navn, "
strSQL = strSQL & "brugernavn, "
strSQL = strSQL & "password, "
strSQL = strSQL & "hjemmeside, "
strSQL = strSQL & "email, "
strSQL = strSQL & "beskrivelse, "
strSQL = strSQL & "foedselsdato, "
strSQL = strSQL & "status, "
strSQL = strSQL & "dato, "
strSQL = strSQL & "nyhedsbrev, "
strSQL = strSQL & "[by], "
strSQL = strSQL & "adminstat, "
strSQL = strSQL & "musicchart_mail, "
strSQL = strSQL & "oprettet) "
strSQL = strSQL & " values( "
strSQL = strSQL & "'" & "strIp" & "',"
strSQL = strSQL & "'" & "navn" & "',"
strSQL = strSQL & "'" & "brugernavn" & "',"
strSQL = strSQL & "'" & "password" & "',"
strSQL = strSQL & "'" & "hjemmeside" & "',"
strSQL = strSQL & "'" & "email" & "',"
strSQL = strSQL & "'" & "beskrivelse" & "',"
strSQL = strSQL & "'" & "20021006" & "',"
strSQL = strSQL & "'" & "member" & "',"
strSQL = strSQL & "'" & "gang" & "',"
strSQL = strSQL & "'" & "nyhedsbrev" & "',"
strSQL = strSQL & "'" & "by" & "',"
strSQL = strSQL & "'" & "1" & "',"
strSQL = strSQL & "'" & "webmaster" & "',"
strSQL = strSQL & "'" & "20021005" & "')"
Conn.Execute(strSQL)
...den kommer med fejlen:
Fejltype:
Microsoft OLE DB Provider for SQL Server (0x80040E57)
String or binary data would be truncated.
