Jacksonville Chapter

Printer Friendly
Text Size: A A A A

Officers

System.Exception: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.WriteSni() at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush() at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 238 DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME --Fiscal Year SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 7)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 ) ) SET @EndDate = DATEADD(SS,-86400,DATEADD(mm,12,@StartDate)) SELECT 'Title' = CASE WHEN CommMembers.PositionDescription='Chapter Director' THEN '' Else CommMembers.PositionDescription + '
' END, 'FullName' = CASE WHEN MemberNames.Nickname='' THEN (rtrim(MemberNames.FirstName) + ' ' + rtrim(ltrim(MemberNames.LastName))) + '
' WHEN MemberNames.Suffix <> '' THEN (rtrim(MemberNames.Nickname) + ' ' + rtrim(ltrim(MemberNames.LastName)) + ', ' + rtrim(ltrim(MemberNames.Suffix))) + '
' Else (rtrim(MemberNames.Nickname) + ' ' + rtrim(ltrim(MemberNames.LastName))) + '
' END, 'Phone' = CASE WHEN MemberNames.dphone='' AND CommMembers.FirmPhone ='' AND CommMembers.PositionDescription<>'Chapter Director' THEN '' + '
' WHEN CommMembers.PositionDescription='Chapter Director' THEN '' WHEN MemberNames.dphone='' THEN '(' + LEFT(rtrim(ltrim(CommMembers.FirmPhone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(CommMembers.FirmPhone)), 5,3) + '-' + RIGHT(rtrim(ltrim(CommMembers.FirmPhone)),4) + '

' WHEN CommMembers.FirmPhone='' THEN '(' + LEFT(rtrim(ltrim(MemberNames.dphone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(MemberNames.dphone)), 5,3) + '-' + RIGHT(rtrim(ltrim(MemberNames.dphone)),4) + '

' Else '(' + LEFT(rtrim(ltrim(MemberNames.dphone)), 3) + ') ' + SUBSTRING(rtrim(ltrim(MemberNames.dphone)), 5,3) + '-' + RIGHT(rtrim(ltrim(MemberNames.dphone)),4) + '

' END FROM CommMembers INNER JOIN MemberNames ON CommMembers.MemberID=MemberNames.MemberID where (CommID = 'JX') AND (PositionDescription <> 'Designated Representative' AND PositionDescription <> 'Chapter Director') AND coend=@EndDate ORDER BY PositionSort at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 250 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

Board of Directors

Bob Boylan
Ellen Bushnell
Mamie Davis
Rick Moyer
Mark Patrick
Van Seaton


Welcome

Welcome to the Florida Institute of CPAs Jacksonville Chapter page. Here you will find information of upcoming events involving our chapter.

Our chapter is committed to the accountancy profession through education, training and community involvement. Our members provide outstanding service to public and private institutions as well as individuals.

Please contact any one of our chapter officers if you have questions or need more information, and I look forward to seeing you at our next event.