
The American Way
Real Estate Co., Inc.
710 South Jefferson
Cookeville, TN 38501
(866) 319-5655 toll free
(931) 526-9581 phone
(931) 528-6569 fax
info@american-way.com |
|
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 'Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,
|
| |
The error occurred in /home/web/a/american-way.com/www/searchmul.cfm: line 214
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 1
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 214
Called from /home/web/a/american-way.com/www/searchmul.cfm: line 1
|
212 : #column# order by #column# </cfquery> <cfif a.recordcount is not 0>
213 : <cfquery name="b" datasource="ucmls" dbtype="#Application.DBType#">
214 : select text,id from features where id in (#valuelist(a.col)#)
215 : order by text
216 : </cfquery>
|
|
| SQLSTATE |
42000 |
| SQL |
select text,id from features where id in (7 Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,Great inco,Great inve,Great pric,Great rent,Income pro,Investment,Investors,Looking fo,Lots and l,Manufactur,NEW DUPLEX,One good d,Sooooooooo,T-3832 Mob,T-3987 Ve,T-4158 Ni,These apar,These Cust,This Custo)
order by text
|
| VENDORERRORCODE |
1064 |
| DATASOURCE |
ucmls |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
192.168.1.4 |
| Referrer |
|
| Date/Time |
09-May-08 07:33 PM |
|
|
Stack Trace
|
at cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214) at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1)
at cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214) at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1)
com.mysql.jdbc.exceptions.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 'Unit apa,Agents, Pl,Also inclu,Attention,AWESOME YE,Each lot i,
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
at com.mysql.jdbc.Statement.execute(Statement.java:706)
at com.mysql.jdbc.Statement.execute(Statement.java:783)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1220)
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 cfsearchmul2ecfm2004189182._factor0(/home/web/a/american-way.com/www/searchmul.cfm:214)
at cfsearchmul2ecfm2004189182.runPage(/home/web/a/american-way.com/www/searchmul.cfm:1)
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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
|
|