Boston Real Estate | Boston Condos | Boston Neighborhoods | Boston MLS | Boston Real Estate Agents

We are sorry, the site is currently undergoing temporary maintenance. Please come back shortly!

struct

Browser

CCBot/1.0 (+http://www.commoncrawl.org/bot.html)

DateTime

{ts '2010-09-06 14:13:35'}

Diagnostics

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. <br>The error occurred on line 520.

GeneratedContent

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta name="description" content="Ballast Realty is a leading boutique Boston real estate agency. Ballast provides full-service sales, marketing and specialty Boston real estate advisory services to Buyers, Sellers and Investors and Developers."> <meta name="keywords" content="Search Boston real estate for sale including property address and photos for free, Boston lofts, Boston condos, Boston condo, Boston brownstones, Boston real estate agents, search entire Boston MLS database for free, find a Boston Buyer's Agent, find a Boston Seller's Agent"> <meta name="abstract" content="The Ballast Boston website lets potential buyers and sellers of Boston real estate search real estate for sale on the MLS database for free and shows potential real estate buyers and sellers real estate property addresses and real estate photos of all Boston condos, multi family homes, single family homes and Boston lofts for sale."> <meta name="website-developer" content="Silverscape - www.silverscape.com"> <meta name="audience" content="All"> <meta name="rating" content="General"> <meta name="distribution" content="Global"> <meta name="revisit-after" content="5 days"> <script language="JavaScript1.2" src="/common/body_jscript.js"></script> <script src="/common/AC_RunActiveContent.js" type="text/javascript"></script> <script src="/common/AC_OETags.js" language="javascript"></script> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Boston Real Estate | Boston Condos | Boston Neighborhoods | Boston MLS | Boston Real Estate Agents - Ballast Realty Group</title> <link rel="stylesheet" type="text/css" href="/styles/standard.css">  <link rel="stylesheet" type="text/css" href="/styles/flexcrollstyles_scrollBG.css"> <link rel="shortcut icon" type="image/gif" href="/favicon.ico"> <script type='text/javascript' src='/common/flexcroll.js'></script> <script defer type="text/javascript" src="/common/pngfix.js"></script> </head> <body style="margin:0px; padding:0px;"> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr> <td height="142" valign="top" align="right" bgcolor="#f7f4eb"> <div style="width:204px; height:142px;"> <div style="width:143px; height:142px; padding:0px 3px 0px 0px; background:#FFFFFF;"><img src="/graphics/TopLeftIMG_my Ballast.jpg" border="0" /></div> </div> </td> <td width="806" height="142" colspan="2" valign="top" align="left"> <table width="806" cellpadding="0" cellspacing="0" border="0"> <tr> <td width="806" height="142"> <table width="507" cellpadding="0" cellspacing="0" border="0"> <tr> <td width="194" height="129" valign="top" align="left"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" align="left" style="padding:0px 0px 0px 3px;"><a href="/index.cfm"><img src="/graphics/BallastBlue_top.gif" alt="Ballast Realty Group" title="Ballast Realty Group" width="70" height="101" border="0" /></a></td> <td valign="top" align="left" style="padding:0px 0px 0px 0px;"><a href="/index.cfm"><img src="/graphics/shim.gif" alt="Ballast Realty Group" title="Ballast Realty Group" width="117" height="101" border="0" /></a></td> </tr> <tr> <td valign="top" align="left" colspan="2" style="padding:0px 0px 0px 3px;"><a href="/index.cfm" title="Ballast Realty Group"><img src="/graphics/Ballast_Realty_Group_logo.gif" alt="Ballast Realty Group" title="Ballast Realty Group" width="187" height="28" border="0" /></a></td> </tr> </table> </td> <td width="293" height="119" valign="bottom" class="Address" align="right" style="padding:0px 14px 10px 0px; border-right:1px solid #c3966c;"><img src="/graphics/ContactIMG.gif" alt="1200 Washington Street Suite 105, Boston, MA 02118 (617.275.5811)" title="1200 Washington Street Suite 105, Boston, MA 02118 (617.275.5811)" width="132" height="68" border="0" usemap="#Map" /></td> </tr> <tr> <td width="507" height="13" valign="top" colspan="2"> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr> <td style="padding:0px 0px 0px 2px;"><img src="/graphics/BallastBlue_bottom.gif" border="0" /></td> <td align="right"><img src="/graphics/WoodPattern.jpg" width="430" height="13" border="0" /></td> </tr> </table> </td> </tr> </table> </td> <td width="299" height="142" valign="top" align="left"><img src="/graphics/TopRightIMG_my Ballast.jpg" width="299" height="142" border="0" /></td> </tr> </table> </td> <td height="142" valign="top" bgcolor="#f7f4eb"><div style="visibility:hidden;">Hide</div></td> </tr> <tr> <td height="3" valign="top" align="right" style="border-bottom:1px solid #c3966c;"><img src="/graphics/shim.gif" height="3" /></td> <td width="555" height="3" valign="top" align="left" style="border-bottom:1px solid #c3966c;"><img src="/graphics/shim.gif" height="3" /></td> <td width="251" height="3" valign="top" align="left" style="border-bottom:1px solid #c3966c;"><img src="/graphics/shim.gif" height="3" /></td> <td height="3" valign="top" style="border-bottom:1px solid #c3966c;"><img src="/graphics/shim.gif" height="3" /></td> </tr> <tr> <td height="168" valign="top" align="right" style="border-right:1px solid #c3966c;"> <div id="subMenu" style="width:100%; float:right;"> <table cellpadding="0" cellspacing="0" border="0" style="margin:10px 10px 10px 0px;"> <tr> <td align="right" valign="top"><a href="/index.cfm/Buying" title="Buying"><img src="/graphics/Link_Buying.gif" onMouseOver="this.src='/graphics/Link_Buying_on.gif';" onMouseOut="this.src='/graphics/Link_Buying.gif';" width="51" height="9" border="0" title="Buying" /></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/Selling" title="Selling"><img src="/graphics/Link_Selling.gif" onMouseOver="this.src='/graphics/Link_Selling_on.gif';" onMouseOut="this.src='/graphics/Link_Selling.gif';" width="53" height="9" border="0" title="Selling" /></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/FeaturedProperties" title="Featured Properties"><img src="/graphics/Link_FeaturedProperties.gif" onMouseOver="this.src='/graphics/Link_FeaturedProperties_on.gif';" onMouseOut="this.src='/graphics/Link_FeaturedProperties.gif';" width="129" height="9" border="0" title="Featured Properties" /></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/BostonLiving" title="Boston Living"><img src="/graphics/Link_BostonLiving.gif" onMouseOver="this.src='/graphics/Link_BostonLiving_on.gif';" onMouseOut="this.src='/graphics/Link_BostonLiving.gif';" width="93" height="9" border="0" title="Boston Living" /></a></td> </tr> <tr> <td align="right" valign="top" style="padding-bottom:0px;"><a href="/index.cfm/Resources" title="Resources"><img src="/graphics/Link_Resources.gif" onMouseOver="this.src='/graphics/Link_Resources_on.gif';" onMouseOut="this.src='/graphics/Link_Resources.gif';" width="71" height="9" border="0" title="Resources" /></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/DeveloperandInvestorServices" title="Developer And InvestorServices"><img src="/graphics/Link_DeveloperAndInvestorServices.gif" alt="Developer & Investor Services" width="135" height="23" border="0" title="Corporate Services & Consulting" onMouseOver="this.src='/graphics/Link_DeveloperAndInvestorServices_on.gif';" onMouseOut="this.src='/graphics/Link_DeveloperAndInvestorServices.gif';" /></a></td> </tr> </table> <div style="border-bottom:1px solid #c3966c; margin-top:34px;"><img src="/graphics/shim.gif" border="0" /></div> <table cellpadding="0" cellspacing="0" border="0" style="margin:10px 10px 10px 0px;"> <tr> <td align="right" valign="top"><a href="/index.cfm/AboutBallast"><img src="/graphics/Link_AboutBallast.gif" onMouseOver="this.src='/graphics/Link_AboutBallast_on.gif';" onMouseOut="this.src='/graphics/Link_AboutBallast.gif';" alt="About Ballast" title="About Ballast" width="89" height="9" border="0"/></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/RealEstateServices"><img src="/graphics/Link_RealEstateServices.gif" onMouseOver="this.src='/graphics/Link_RealEstateServices_on.gif';" onMouseOut="this.src='/graphics/Link_RealEstateServices.gif';" alt="Real Estate Services" width="118" height="9" border="0"/></a></td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm/OurAgents" title="Our Agents"><img src="/graphics/Link_OurAgents.gif" onMouseOver="this.src='/graphics/Link_OurAgents_on.gif';" onMouseOut="this.src='/graphics/Link_OurAgents.gif';" title="Our Agents" alt="Our Agents" width="72" height="9" border="0"/></a></td> </tr> <tr> <td align="right" valign="top" style="padding-bottom:0px;"> <a href="/index.cfm/OurClients" title="Our Clients"><img src="/graphics/Link_OurClients.gif" onMouseOver="this.src='/graphics/Link_OurClients_on.gif';" onMouseOut="this.src='/graphics/Link_OurClients.gif';" alt="Our Clients" title="Our Clients" width="72" height="9" border="0"/></a> </td> </tr> <tr> <td align="right" valign="top"> <a href="/index.cfm/MyBallast"><img src="/graphics/Link_MyBallast.gif" onMouseOver="this.src='/graphics/Link_MyBallast_on.gif';" onMouseOut="this.src='/graphics/Link_MyBallast.gif';" alt="My Ballast" width="71" height="9" border="0"/></a> </td> </tr> <tr> <td align="right" valign="top"> <a href="/index.cfm/BallastClientTransactionCenter"><img src="/graphics/Link_CTC.gif" onMouseOver="this.src='/graphics/Link_CTC_on.gif';" onMouseOut="this.src='/graphics/Link_CTC.gif';" alt="Ballast Client Transaction Center" title="Ballast Client Transaction Center" width="105" height="22" border="0"/></a> </td> </tr> <tr> <td align="right" valign="top"> <a href="/index.cfm/ContactUs"><img src="/graphics/Link_ContactUs.gif" onMouseOver="this.src='/graphics/Link_ContactUs_on.gif';" onMouseOut="this.src='/graphics/Link_ContactUs.gif';" alt="Contact Us" width="74" height="9" border="0"/></a> </td> </tr> <tr> <td align="right" valign="top"> <a href="/myBallast/index.cfm"><img src="/graphics/Link_Login.gif" onMouseOver="this.src='/graphics/Link_Login_on.gif';" onMouseOut="this.src='/graphics/Link_Login.gif';" alt="Login" title="Login" width="43" height="9" border="0"/></a> </td> </tr> <tr> <td align="right" valign="top"><a href="/index.cfm" class="nav0" title="Home" style="padding:4px 0px 0px 0px;"><img src="/graphics/Link_home.gif" onMouseOver="this.src='/graphics/Link_home_on.gif';" onMouseOut="this.src='/graphics/Link_home.gif';" alt="Home" title="Home" width="43" height="9" border="0"/></a></td> </tr> </table> <div style="margin:17px 10px 0px 0px;"> <form action="/index.cfm/Search" method="post" name="Criteria" style="margin: 0px; padding: 0px;"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td width="87" height="17" valign="top" align="left" style="padding:0px; margin:0px; white-space:nowrap;"><input type="text" name="Criteria" value="site search" style="width:85px; height:16px; padding:1px 0px 0px 2px; margin:0px; border:1px solid #d2b091; border-right:0px; background:url(/graphics/SearchBox_Bg.gif) top left repeat #fbf9f5; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; color:#936141;" onfocus="this.value='';" /></td> <td width="19" height="19" valign="middle" align="left" style="background-color:#fbf9f5; padding:0px; margin:0px; white-space:nowrap;"><input type="image" src="/graphics/SearchFinder.gif" width="19" height="19" border="0" /></td> </tr> </table> </form> </div> </div> </td> <map name="Map" id="Map"><area shape="rect" coords="70,53,132,68" href="/index.cfm/ContactUs" target="_self" alt="Email Ballast" /></map>

HTTPReferer

[empty string]

Mailto

max@silverscape.com

Message

Error Executing Database Query.

QueryString

action=detail&mid=70816363

RemoteAddress

38.107.191.117

RootCause

struct

Cause

struct

ErrorCode

156

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.

NextException

struct

ErrorCode

8180

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

SQLState

HY000

StackTrace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. 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.TDSRPCRequest.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.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1249) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520) at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm) at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483) at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. 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.TDSRPCRequest.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.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1249) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520) at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm) at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483) at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Type

java.sql.SQLException

DataSource

ballast_SQLdata

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.

ErrorCode

HY000

Message

Error Executing Database Query.

NativeErrorCode

156

RootCause

struct

ErrorCode

156

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.

NextException

struct

ErrorCode

8180

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

SQLState

HY000

StackTrace

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

Sql

SELECT * FROM WHERE list_no = (param 1)

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520) at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm) at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483) at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'. 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.TDSRPCRequest.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.BasePreparedStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source) at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown Source) at coldfusion.sql.Executive.executeQuery(Executive.java:1249) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 39 more

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Type

Database

queryError

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WHERE'.

where

(param 1) = [type='IN', class='java.lang.Integer', value='70816363', sqltype='cf_sql_integer']

StackTrace

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	520
RAW_TRACE	at cfindex2ecfm428837174._factor118(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:520)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	-1
RAW_TRACE	at cfindex2ecfm428837174._factor28(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm)
TEMPLATE	C
TYPE	CFML

struct
COLUMN	0
ID	C
LINE	483
RAW_TRACE	at cfindex2ecfm428837174._factor193(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:483)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_INDEX
LINE	1
RAW_TRACE	at cfindex2ecfm428837174.runPage(C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm:1)
TEMPLATE	C:\WEB_HOSTING\ballast\plugins\mlssearch\index.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	50
RAW_TRACE	at cfpage_mls2ecfm956737670.runPage(C:\WEB_HOSTING\ballast\handlers\page_mls.cfm:50)
TEMPLATE	C:\WEB_HOSTING\ballast\handlers\page_mls.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	74
RAW_TRACE	at cfindex2ecfm1171032370.runPage(C:\WEB_HOSTING\ballast\index.cfm:74)
TEMPLATE	C:\WEB_HOSTING\ballast\index.cfm
TYPE	CFML

Template

/index.cfm

Type

coldfusion.runtime.CfErrorWrapper