SQL-sats fungerar inte i MySQL

2 svar · 197 visningar · startad av i-or 5 okt. 2002

i-orMedlem sedan nov. 2001294 inlägg

Trådstart5 okt. 2002 19:20#1

Hur ska jag göra om denna SQL-sats så att den fungerar i MySQL:

SQL = "SELECT Max(C) AS f_max FROM (SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date))"

Felmeddelande:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = 1 GROUP BY Year(f_dat' at line 1

LarsGMedlem sedan dec. 200012 464 inlägg

5 okt. 2002 19:38#2

SQL = "SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date) order by c desc limit 1"

i-orMedlem sedan nov. 2001294 inlägg

5 okt. 2002 19:41#3

Tack så mycket för det snabba svaret!