vad är det för fel med detta:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax near '(nvarchar(10), [datum], 20) AS FormDate, convert(nvarchar(5), [datum], 8) AS For' at line 1

/NoN/avdelning.asp, rad 23

koden är:

set RecSets = Connect.Execute("SELECT *, convert(nvarchar(10), [datum], 20) AS FormDate, convert(nvarchar(5), [datum], 8) AS FormTime FROM Textbas where Avdelning = " & Avdelning & " ORDER BY Datum DESC")


Jag kör ASP mot MySQL