MOAA Websites by NPD

MOAA Websites by NPD MOAA Websites by NPD

News Event Calendar

MOAA Websites by NPD

MOAA Websites by NPD MOAA Websites by NPD

Why you should be using Email Marketing?

When it comes to converting Veterans into MOAA Chapter members, email marketing is the way to...
Read More

Register for News Story Emails.

MOAA Websites by NPD

Site Navigation: Collapse

> Home Page
> About
> The Perfect Website
    > 85 Apps
      > Major Applications
    > Delegated Page Access
    > Administrative Control
    > Content Variables
    > Email Communications
    > Special Content
    > Site Navigation
    > Integrated Social Medi
    > Smartphone Compatibili
    > Membership Management
    > MOAA CIC
    > Ecommerce Options
    > Internet Security
    > Customer Support
> Surveys
> News
> Calendar
    > Upcoming Events

> Features
> Site Components
    > Content Management
    > Applications
    > Content Development
    > E Commerce
    > Support
    > Administration
> Software Upgrades

> Benefits

> Details
> Q and A

> Clients
> Testimonials

> Contact NPD
> Email Form

Site Navigation

Your NPD website can be populated with an unlimited number of pages. But they need to organized in a way that makes information easy to find.

So I designed my NPD MOAA website navigation scheme to be something like a file cabinet.

The drawers of this cabinet contain "Level 1" pages, which appear in the main navigation bar on every website page:

Now imagine that each drawer contains folders, which correspond to Level 2 pages, as defined under the parent Level 1 page:

Each folder might contain pages, which correspond to Level 3 pages, as defined under its parent Level 2 page:

And while it's rarely necessary, you can create Level 4 pages in a similiar fashion:

What's more, every page includes a Navigation template on the left panel:

MOAA Websites by NPD

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

The error occurred in C:/home/nonprofitdynamics.com/subdomains/moaa/template_subpage3.cfm: line 31
Called from C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm: line 804
Called from C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm: line 1
Called from C:/home/nonprofitdynamics.com/subdomains/moaa/template_subpage3.cfm: line 31
Called from C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm: line 804
Called from C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm: line 1

29 : 	*
30 : 	FROM pagesub3
31 : 	where pagesub2id = #getpagesub2.pagesub2id#
32 : 	</CFQUERY>
33 :

SQLSTATE	42000
DATASOURCE	npd_moaa_five
VENDORERRORCODE	1064
SQL	SELECT * FROM pagesub3 where pagesub2id =

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	3.138.105.41
Referrer
Date/Time	26-Apr-24 06:46 AM

Stack Trace

at cftemplate_subpage32ecfm1215647762.runPage(C:/home/nonprofitdynamics.com/subdomains/moaa/template_subpage3.cfm:31) at cfpagesub22ecfm1901996136._factor13(C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm:804) at cfpagesub22ecfm1901996136.runPage(C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm:1) at cftemplate_subpage32ecfm1215647762.runPage(C:/home/nonprofitdynamics.com/subdomains/moaa/template_subpage3.cfm:31) at cfpagesub22ecfm1901996136._factor13(C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm:804) at cfpagesub22ecfm1901996136.runPage(C:/home/nonprofitdynamics.com/subdomains/moaa/pagesub2.cfm:1)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
	at jdk.internal.reflect.GeneratedConstructorAccessor166410.newInstance(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:928)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cftemplate_subpage32ecfm1215647762.runPage(C:\home\nonprofitdynamics.com\subdomains\moaa\template_subpage3.cfm:31)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfpagesub22ecfm1901996136._factor13(C:\home\nonprofitdynamics.com\subdomains\moaa\pagesub2.cfm:804)
	at cfpagesub22ecfm1901996136.runPage(C:\home\nonprofitdynamics.com\subdomains\moaa\pagesub2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)