Site hosted by Angelfire.com: Build your free website today!

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 're'.
 
The error occurred in D:\Projects\Current\WWW\TMR\Archivist\Beta\component\qry_nllib.cfc: line 30
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 86
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 124
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 44
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\parsed\ccontroller.fcontrolnewsletteradd.cfm: line 72
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 433
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 426
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 1
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\index.cfm: line 2
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\component\qry_nllib.cfc: line 30
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 86
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 124
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm: line 44
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\parsed\ccontroller.fcontrolnewsletteradd.cfm: line 72
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 433
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 426
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm: line 1
Called from D:\Projects\Current\WWW\TMR\Archivist\Beta\index.cfm: line 2
28 : 
29 : 			SELECT COUNT(*) AS int_num_records FROM #str_tbl_name#  
30 : 					WHERE #Replace(str_add_condition,"''","'","ALL")#
31 : 		</cfquery>
32 : 		<cfif isValueExists.int_num_records GT 0>

SQL    SELECT COUNT(*) AS int_num_records FROM tbl_template WHERE tpl_template_title='What're you waiting for!!?'
DATASOURCE   dsn_db_beta_archivist
VENDORERRORCODE   170
SQLSTATE   HY000
Please try the following:

Browser   Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7
Remote Address   192.168.0.10
Referrer   http://61.17.42.151:81/index.cfm?fuseaction=cController.fControlNewsletterAdd
Date/Time   08-Oct-05 02:47 PM
Stack Trace
at cfqry_nllib2ecfc1760786290$funcISVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\component\qry_nllib.cfc:30) at cfact_20newsletter_add2ecfm448746694$funcCHECKVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:86) at cfact_20newsletter_add2ecfm448746694$funcVALIDATEFORM.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:124) at cfact_20newsletter_add2ecfm448746694.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:44) at cfccontroller2efcontrolnewsletteradd2ecfm1835989490.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\parsed\ccontroller.fcontrolnewsletteradd.cfm:72) at cffusebox42eruntime2ecfmx2ecfm1656340506._factor15(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:433) at cffusebox42eruntime2ecfmx2ecfm1656340506._factor17(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:426) at cffusebox42eruntime2ecfmx2ecfm1656340506.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:1) at cfindex2ecfm77009487.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\index.cfm:2) at cfqry_nllib2ecfc1760786290$funcISVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\component\qry_nllib.cfc:30) at cfact_20newsletter_add2ecfm448746694$funcCHECKVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:86) at cfact_20newsletter_add2ecfm448746694$funcVALIDATEFORM.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:124) at cfact_20newsletter_add2ecfm448746694.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:44) at cfccontroller2efcontrolnewsletteradd2ecfm1835989490.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\parsed\ccontroller.fcontrolnewsletteradd.cfm:72) at cffusebox42eruntime2ecfmx2ecfm1656340506._factor15(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:433) at cffusebox42eruntime2ecfmx2ecfm1656340506._factor17(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:426) at cffusebox42eruntime2ecfmx2ecfm1656340506.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:1) at cfindex2ecfm77009487.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\index.cfm:2)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 're'.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:705)
	at coldfusion.sql.Executive.executeQuery(Executive.java:638)
	at coldfusion.sql.Executive.executeQuery(Executive.java:599)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498)
	at cfqry_nllib2ecfc1760786290$funcISVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\component\qry_nllib.cfc:30)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:370)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:156)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:345)
	at cfact_20newsletter_add2ecfm448746694$funcCHECKVALUEINDB.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:86)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1800)
	at cfact_20newsletter_add2ecfm448746694$funcVALIDATEFORM.runFunction(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:124)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1800)
	at cfact_20newsletter_add2ecfm448746694.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\model\admin\newsletter\act_ newsletter_add.cfm:44)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908)
	at cfccontroller2efcontrolnewsletteradd2ecfm1835989490.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\parsed\ccontroller.fcontrolnewsletteradd.cfm:72)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908)
	at cffusebox42eruntime2ecfmx2ecfm1656340506._factor15(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:433)
	at cffusebox42eruntime2ecfmx2ecfm1656340506._factor17(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:426)
	at cffusebox42eruntime2ecfmx2ecfm1656340506.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\fusebox4.runtime.cfmx.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908)
	at cfindex2ecfm77009487.runPage(D:\Projects\Current\WWW\TMR\Archivist\Beta\index.cfm:2)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)