Server Error in '/stjames' Application.

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:


Line 658:        'Response.Write(sql)
Line 659:
Line 660:        sql = "SELECT pcName, pcID " & _
Line 661:              "FROM vw_Photo_Category " & _
Line 662:              "WHERE Year(pcDate)=" & CInt(Request("year")) & " And pcStatus=1 And pcSiteID=" & SiteID & " "

Source File: E:\www_hosting\dhk.hkskh.org\parish\photo_gallery.aspx.vb    Line: 660

Stack Trace:


[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +201
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +66

[InvalidCastException: Conversion from string "" to type 'Integer' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) +246
   photo_gallery.GetAlbumList() in E:\www_hosting\dhk.hkskh.org\parish\photo_gallery.aspx.vb:660
   photo_gallery.Page_Load(Object sender, EventArgs e) in E:\www_hosting\dhk.hkskh.org\parish\photo_gallery.aspx.vb:122
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


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