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

Errore nel codice sorgente:


Riga 1043:		Dim SQLCode3 = "select * from province where idreg = " & regioneb & " order by provinciait asc"
Riga 1044:		Dim Cmd3 = New MySqlCommand(SQLCode3, con3)
Riga 1045:		datareader3 = Cmd3.ExecuteReader
Riga 1046:		If datareader3.HasRows Then
Riga 1047:			While (datareader3.Read)

File di origine: e:\hosts\siti\biomeccanico.com\default.aspx    Riga: 1045

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 provinciait 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\siti\biomeccanico.com\default.aspx:1045
   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