GESTIONE ERRORI NOLEGGIO EXPERT

Pagina Errore:	station-wagon.aspx?ORDER=FBCA535CCA7E3631&TCID=69E249352AF79723&range=fbca535cca7e3631&tbid=461c0e6aa5017ce9
Err.Query:	SELECT * FROM vs_elenco_veicoli_public WHERE usato_auto_key IN (SELECT usato_auto_key FROM vs_stationwagon) AND tab_carburante_key = 3 AND tab_categoria_key = 2 AND prezzo_internet > '100 ' AND prezzo_internet <= '200 ' ORDER BY 100-200
Err.Method:	OnError
Err.Description:	Rilevata espressione costante nell'elenco della clausola ORDER BY, alla posizione 1.
Err.StackTrace:	at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at Noleggi_Dati.LetturaDati.LeggiVs_elenco_veicoli_public.LeggiVs_elenco_veicoli_public(String Filtro, String Top, String OrderBY, String GetCollection, String GetObject, DbConnection cn, DbTransaction tn) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Dati\Lettura\LeggiVs_elenco_veicoli_public.vb:line 67 at Noleggi_Servizi.Lettura.LetturaVs_elenco_veicoli_public.LetturaVs_elenco_veicoli_public(String Filtro, String Top, String OrderBY, String GetCollection, String GetObject, DbConnection cn, DbTransaction tn) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Servizi\Lettura\LetturaVs_elenco_veicoli_public.vb:line 11 at Noleggi_Servizi.Lettura.LetturaVs_elenco_veicoli_public.LetturaVs_elenco_veicoli_public(String Filtro, String OrderBY, String GetCollection, String GetObject, DbConnection cn) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Servizi\Lettura\LetturaVs_elenco_veicoli_public.vb:line 20 at Noleggio_Expert_Web.Lista.CaricaElencoAuto(String filter, String order) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Web\Lista.aspx.vb:line 555 at Noleggio_Expert_Web.Lista.ReloadElenco(Usato_Ricerca ricerca) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Web\Lista.aspx.vb:line 523 at Noleggio_Expert_Web.Lista.riempiPagina() in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Web\Lista.aspx.vb:line 216 at Noleggio_Expert_Web.Lista.Page_Load(Object sender, EventArgs e) in C:\Dati\Progetti\Connecta\Noleggi.Expert\Noleggi_Web\Noleggi_Web\Lista.aspx.vb:line 59 at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Home   Prosegui