Fejl i Insert
Nu har jeg set mig blind på en insert linie i min ASP kode, og kan simpelthen ikke se hvad der er gået galt, følgende kode insætter data i DB:strSQL = "INSERT INTO content ("
strSQL = strSQL & "[ContentName],"
strSQL = strSQL & "[Content],"
strSQL = strSQL & "[Active],"
strSQL = strSQL & "[MenuID],"
strSQL = strSQL & "[Sorted],"
strSQL = strSQL & "[CreateDate],"
strSQL = strSQL & "[OnlineDate],"
strSQL = strSQL & "[OfflineDate]"
strSQL = strSQL & " VALUES ("
strSQL = strSQL & "'"& contentname & "',"
strSQL = strSQL & "'"& txtContent & "',"
strSQL = strSQL & "" & active & ","
strSQL = strSQL & ""& menuid &","
strSQL = strSQL & ""& sorted &","
strSQL = strSQL & "#"& createdate &"#,"
strSQL = strSQL & "#"& onlinedate &"#,"
strSQL = strSQL & "#"& offlinedate &"#"
strSQL = strSQL & ");"
conn.execute(strSQL)
Med ved insert giver den mig en fejl,
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Data ser sådan her ud,
INSERT INTO content ([ContentName],[Content],[Active],[MenuID],[Sorted],[CreateDate],[OnlineDate],[OfflineDate] VALUES ('xvxvvx','aas',False,40,10,#20/10/2007 18:59:34#,#20/10/2007 17:55#,#20/10/2008 17:55#);
DB er sat sådan her op,
ContentName = tekst
Content = notat
Active = True/False
MenuID = Tal
Sorted = Tal
CreateDate = Dato
OnlineDate = Dato
OfflineDate = Dato
Kan du se hvad der er gået galt her, tak.
