Errore server nell'applicazione '/'.

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 comuneit asc' at line 1

Descrizione: Eccezione non gestita durante l'esecuzione della richiesta Web corrente. Per ulteriori informazioni sull'errore e sul suo punto di origine nel codice, vedere la traccia dello stack.

Dettagli eccezione: MySql.Data.MySqlClient.MySqlException: 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 comuneit asc' at line 1

Errore nel codice sorgente:


Riga 4748:				Dim SQLCode4 = "select * from comuni where idpro = " & provinciab & " order by comuneit asc"
Riga 4749:				Dim Cmd4 = New MySqlCommand(SQLCode4, con4)
Riga 4750:				datareader4 = Cmd4.ExecuteReader
Riga 4751:				If datareader4.HasRows Then
Riga 4752:					While (datareader4.Read)

File di origine: E:\hosts\terzi-livelli\sondaggiocannedrenanti.trivelpozzi.it\default.aspx    Riga: 4750

Traccia dello stack:


[MySqlException (0x80004005): 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 comuneit asc' at line 1]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +272
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) +68
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) +17
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +100
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +761
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1585
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +6
   ASP.default_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in E:\hosts\terzi-livelli\sondaggiocannedrenanti.trivelpozzi.it\default.aspx:4750
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +268
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +13
   System.Web.UI.Page.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +66
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1303


Informazioni di versione: Versione di Microsoft .NET Framework:4.0.30319; Versione di ASP.NET:4.7.4076.0