Broker Check

Welcome

GCSB Investment Center originated in 2002 to provide investment and retirement products to customers interested in exploring their financial options. Through IBA Securities, a division of Broker Dealer Financial Services Corp, we offer a wide variety of products including individual, retirement and corporate investment accounts. Whether planning for retirement, a child’s upcoming college tuition or to review your current investment strategy, now is a great time to sit down with our investment representative. We will review your portfolio and make recommendations at no cost and with no obligation.

We know managing your investment portfolio can be overwhelming and frustrating, particularly if you have accounts with multiple companies. We often work with clients who have left a 401K or other retirement-type investment with a previous employer’s fund manager because they didn’t want to deal with the perceived hassle of transferring the account.

GCSB Investment Center can help you consolidate your accounts and manage your portfolio with more intention and a solid strategy based on your needs. Once you initiate the transfers, we will take care of the paperwork and work with you to streamline your reports. The result? You have more time to do what you do, while we use our expertise to help manage your hard-earned investment dollars.

Products and services offered include management of:

  • stocks
  • corporate bonds and tax-free municipal bonds
  • certificates of deposit
  • closed and exchange traded funds
  • mutual funds
  • fee-based portfolio platforms

We are also licensed to sell and manage insurance products such as annuities, life and variable insurance, and long-term care coverage.


Debugging Information
ColdFusion Server Developer 2018,0,02,313961
Template /home-content.cfm
Time Stamp 07-Jul-20 11:13 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.236.108.61
Host Name 3.236.108.61


Execution Time

Total Time Avg Time Count Template
16 ms 16 ms 1 d:/sites/GCSBIC/html/Application.cfm
15 ms 15 ms 1 D:/Sites/DWebCMS/website/index.cfm
15 ms 15 ms 1 D:/Sites/GCSBIC/html/index.cfm
15 ms 15 ms 1 D:/Sites/GCSBIC/template.cfm
15 ms 15 ms 1 d:/sites/GCSBIC/html/home-content.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/browser.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/hacker.cfm
0 ms 0 ms 1 C:/ColdFusion2018/cfusion/CustomTags/scriptkill.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/Application.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/body.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/head.cfm
0 ms 0 ms 1 D:/Sites/DWebCMS/website/share/udfs.cfm
0 ms 0 ms 1 d:/sites/GCSBIC/html/OnRequestEnd.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
31 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getSiteXML (Datasource=DWebCMS, Time=0ms, Records=1) in d:\sites\GCSBIC\html\Application.cfm @ 11:13:45.045
	SELECT	xmlSiteInfo
	FROM	tblWebsiteInfo
	WHERE	unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
getPages (Datasource=DWebCMS, Time=0ms, Records=9) in D:\Sites\DWebCMS\website\head.cfm @ 11:13:45.045
	SELECT	P.unqPageID,
			P.unqPageTypeID,
			P.vchFileName,
			P.vchLink,
			P.vchLinkTarget,
			C.vchPageName,
			C.unqNavTypeID,
			C.vchLiveNavContent,
			C.unqNavStoreWareInstanceId,
			C.unqNavMediaGalleryId,
			C.unqNavCalendarId,
			C.unqNavNewsID,
			C.unqNavFAQID,
			C.vchNavIncludeFile
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
	
	AND		P.bitActive = 1
	
	AND		P.bitShowOnNav = 1
	
	AND		P.unqParentPageID IS NULL
	ORDER BY P.intSortId
getCurrentPage (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\DWebCMS\website\head.cfm @ 11:13:45.045
 
	SELECT	P.unqPageTypeID,
			P.unqParentPageId,
			P.unqStoreWareInstanceId,
			P.unqPhotoGalleryId,
			P.unqCalendarId,
			P.unqNewsCategoryID,
			P.unqPageTurnId,
			P.unqFAQCategoryID,
			P.vchFileName,
			C.vchPageName,
			C.vchPageSubtitle,
			C.txtLivePageContent,
			C.vchLiveUnsecuredContent,
			C.vchTitle,
			C.txtDescription,
			C.txtKeywords,
			P.vchLink,
			P.vchLinkTarget,
			P.vchIncludeFile,
			P.xmlPageVariables,
			P.vchEmail,
			hasSecurity = (SELECT COUNT(unqPageGroupID) FROM tblWebsitePageGroup WHERE unqPageID = P.unqPageID)
	FROM	tblWebsitePages P
		INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
		INNER JOIN tblPageContentTypes T ON (C.unqPageContentTypeID = T.unqPageContentTypeID AND T.vchPageContentType = 'Desktop')
	WHERE	P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
	AND		P.unqPageID = '21e43a91-f316-4b5b-9b8a-54d8e9115d7a'
	
		AND		P.bitActive = 1
		
getNews (Datasource=DWebCMS, Time=0ms, Records=2) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
    WITH ItemsInternal AS (
        SELECT  NAL.*,
                NA.vchAuthor,
                NC.*,
                NCL.vchCategoryName,
                NCL.unqNewsCategoryTypeId,
                vchFileName = (
                    SELECT  TOP 1 vchFilename
                    FROM    tblWebsitePages
                    WHERE   unqCustomerID = ?
                    AND     unqPageTypeId = '6661a8d6-eaaf-475c-9883-b6a3ffa316e8'
                    AND     bitActive = 1
                    AND     (unqNewsCategoryID = NC.unqNewsCategoryId
                    OR      unqNewsCategoryID IS NULL)
                    ORDER BY unqNewsCategoryID DESC
                    ),
                COALESCE(NA.datArticleDate, CAST((STR( YEAR( GETDATE() ) ) + '/' + STR( MONTH( GETDATE() ) ) + '/' + STR( DAY( GETDATE()))) AS DATETIME)) AS datArticleDate
        FROM    SysApp_v2_NewsArticles NA
        JOIN SysApp_v2_NewsArticleLocalizations NAL
                ON (NA.unqNewsArticleId = NAL.unqNewsArticleId AND NAL.unqLanguageId = ?)
        JOIN SysApp_v2_NewsCategories NC
                ON (NC.unqNewsCategoryId = NA.unqNewsCategoryId AND NC.unqCustomerId = ?)
        JOIN SysApp_v2_NewsCategoryLocalizations NCL
                ON (NC.unqNewsCategoryId = NCL.unqNewsCategoryId AND NCL.unqLanguageId = ?)
        WHERE   NAL.unqLanguageId = ?
        AND     NAL.bitActive = ?
        AND     NA.bitFeatured = ?
        AND     (NA.datDisplayStartDate IS NULL OR NA.datDisplayStartDate <= {d '2020-07-07'})
        AND     (NA.datDisplayEndDate IS NULL OR DateAdd(d, 1, NA.datDisplayEndDate) >= {d '2020-07-07'})
        ),
        Items AS (
        SELECT  *,
                ROW_NUMBER() OVER (ORDER BY datArticleDate DESC, vchArticleTitle) AS RowNumber
        FROM    ItemsInternal
        )
    SELECT  TOP 2 *,
            TotalRecords = (SELECT COUNT(*) FROM Items)
    FROM    Items
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = a914b834-655e-4aef-902d-450f3b04ca9b
Parameter #2(cf_sql_varchar) = 385e8678-ffdc-4169-a1b5-2d5a2f248d64
Parameter #3(cf_sql_varchar) = a914b834-655e-4aef-902d-450f3b04ca9b
Parameter #4(cf_sql_varchar) = 385e8678-ffdc-4169-a1b5-2d5a2f248d64
Parameter #5(cf_sql_varchar) = 385e8678-ffdc-4169-a1b5-2d5a2f248d64
Parameter #6(cf_sql_bit) = YES
Parameter #7(cf_sql_bit) = YES

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 74258C64-C617-41F5-9E96-9E746D6DDA89

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 3309EF17-DF1F-4FF7-8766-9608979F2D3F

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = A9C5A949-C314-4324-B8EA-A935F3D11186

getChildPages (Datasource=DWebCMS, Time=15ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 567C7802-155D-00D3-039E-D4B8152BE2B2

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = E1097111-81B3-45CF-89EA-BCC4F8657465

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 0BA6E7AB-F0F6-F4AF-CA08-7FC09E3674FE

getChildPages (Datasource=DWebCMS, Time=0ms, Records=1) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = 0BA9B6C5-C813-575C-9DFE-606CA762E175

getChildPages (Datasource=DWebCMS, Time=0ms, Records=0) in D:\Sites\GCSBIC\template.cfm @ 11:13:45.045
                                SELECT  P.*,
                                        C.vchPageName
                                FROM    tblWebsitePages P
                                    INNER JOIN tblWebsitePageContent C ON (P.unqPageID = C.unqPageID AND C.unqLanguageID = '385e8678-ffdc-4169-a1b5-2d5a2f248d64')
                                WHERE   P.unqCustomerID = 'a914b834-655e-4aef-902d-450f3b04ca9b'
                                AND     P.bitActive = 1
                                AND     P.unqParentPageID = ?
                                ORDER BY P.intSortID
                            
Query Parameter Value(s) -
Parameter #1(cf_sql_char) = FA797C96-C91B-4019-821C-A59F2B0CD869


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=d:\sites\GCSBIC\html\home-content.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=gcsbic.devwebware.com
HTTP_REFERER=
HTTP_URL=/home-content.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.13
PATH_INFO=
PATH_TRANSLATED=d:\sites\GCSBIC\html\home-content.cfm
QUERY_STRING=
REMOTE_ADDR=3.236.108.61
REMOTE_HOST=3.236.108.61
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/home-content.cfm
SERVER_NAME=gcsbic.devwebware.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Debug Rendering Time: 16 ms