System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by eventdate' at line 1 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteReader() at ASP.events_aspx.ExecuteSQL(Object strSQL) in C:\Inetpub\vhosts\spiritedwomensnetwork.com.au\httpdocs\include_Files\db.aspx:line 56System.InvalidOperationException: Invalid attempt to call Read when reader is closed. at System.Data.Odbc.OdbcDataReader.Read() at ASP.events_aspx.Runsql(String StrSQL) in C:\Inetpub\vhosts\spiritedwomensnetwork.com.au\httpdocs\include_Files\db.aspx:line 153System.InvalidCastException: Conversion from string "" to type 'Date' is not valid. at Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value) at ASP.events_aspx.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\spiritedwomensnetwork.com.au\httpdocs\Events.aspx:line 51
|
|||||||||||||||
|