Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30205: End of statement expected.

Source Error:


Line 12:             Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Line 13:     
Line 14:             Dim queryString As String = "SELECT 'Alberto Sughi <br><b>  '  RTRIM(Titolo)   '<br> </b>'  RTRIM (Tecnica) ''   ', '  RTRIM (Misura) ''   '<br> ('  RTRIM(Anno) ')'  '<br> <br> <br> <br> <br> <br> <br>' AS Caption_A, IDpaintings, Titolo, Tecnica, Misura, Anno FROM jpgs WHERE Tecniche = 'Oli' AND Anno LIKE '1991' Or Tecniche = 'Oli' AND Anno Like '1992'  Or Tecniche = 'Acrilici' AND Anno Like '1992'ORDER BY " & sortBy   " Asc "
Line 15:             Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
Line 16:             dbCommand.CommandText = queryString

Source File: \\smb-whst-www01\whst_www01$\DDA04B\user\albertosughi.com\f_datagrids\1991_92.aspx    Line: 14





Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062