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

Det ser ut som MS SQL Server's Convert funktion.

Testa istället:

set RecSets = Connect.Execute("SELECT *, CONVERT([datum], DATE) AS FormDate, CONVERT([datum], TIME) AS FormTime FROM Textbas where Avdelning = " & Avdelning & " ORDER BY Datum DESC")

nu får jag detta:

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

[TCX][MyODBC]You have an error in your SQL syntax near '([datum], DATE) AS FormDate, CONVERT([datum], TIME) AS FormTime FROM Textbas whe' at line 1

/NoN/avdelning.asp, rad 23

Testa att skippa [ och ]:

set RecSets = Connect.Execute("SELECT *, CONVERT(datum, DATE) AS FormDate, CONVERT(datum, TIME) AS FormTime FROM Textbas where Avdelning = " & Avdelning & " ORDER BY Datum DESC")