Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
|
| |
The error occurred in D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm: line 170
Called from D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm: line 1
Called from D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm: line 170
Called from D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm: line 1
|
168 : App_Date
169 : FROM Apps
170 : WHERE App_ID = #url.id#
171 : </cfquery>
172 :
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
wbtsinc_gm |
| VENDORERRORCODE |
102 |
| SQL |
SELECT App_FName,
App_LName,
App_Address,
App_City,
App_State,
App_Zip,
App_Phone,
App_Cell,
App_Work,
App_Email1,
App_Email2,
App_CallTime,
App_HowHear,
App_WhyWant,
App_Spec,
App_OppSex,
App_WhatPer,
App_PrevOwner,
App_PetWork,
App_Breeder,
App_KenName,
App_OD,
App_ODSpec,
App_ODBehave,
App_ODSN,
App_Cats,
App_CatsDogs,
App_OPets,
App_Active,
App_Trained,
App_AKC,
App_AKCWhere,
App_Vet,
App_VetNoWhy,
App_VetName,
App_VetAddress,
App_VetPhone,
App_Food,
App_Fence,
CASE
WHEN App_FenceHt = ''
THEN ''
WHEN App_FenceHt = 1
THEN '3 ft.'
WHEN App_FenceHt = 2
THEN '4 ft.'
WHEN App_FenceHt = 3
THEN '5 ft.'
WHEN App_FenceHt = 4
THEN '6 ft.'
WHEN App_FenceHt = 5
THEN 'Over 6 ft.'
END AS App_FenceHt,
CASE
WHEN App_FenceType = ''
THEN ''
WHEN App_FenceType = 1
THEN 'Wood'
WHEN App_FenceType = 2
THEN 'Chain Link'
WHEN App_FenceType = 3
THEN 'Other'
END AS App_FenceType,
App_Yard,
App_Acc,
App_HomeDay,
CASE
WHEN App_AloneHr = ''
THEN ''
WHEN App_AloneHr = 1
THEN '1-2'
WHEN App_AloneHr = 2
THEN '2-4'
WHEN App_AloneHr = 3
THEN '4-6'
WHEN App_AloneHr = 4
THEN '6-8'
WHEN App_AloneHr = 5
THEN '8 +'
END AS App_AloneHr,
App_AloneStay,
App_Home,
App_HomeType,
App_Restict,
App_Vac,
App_Crate,
App_ChildAge,
App_AllWant,
App_Abide,
App_Question,
App_Date
FROM Apps
WHERE App_ID = |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
18.116.82.202 |
| Referrer |
|
| Date/Time |
01-May-25 06:32 PM |
|
|
Stack Trace
|
at cfViewApp2ecfm1509789985._factor13(D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm:170) at cfViewApp2ecfm1509789985.runPage(D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm:1)
at cfViewApp2ecfm1509789985._factor13(D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm:170) at cfViewApp2ecfm1509789985.runPage(D:/Websites/goldenmelodies.com/Prospects/ViewApp.cfm:1)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1531)
at coldfusion.sql.Executive.executeQuery(Executive.java:1281)
at coldfusion.sql.Executive.executeQuery(Executive.java:1211)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1202)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfViewApp2ecfm1509789985._factor13(D:\Websites\goldenmelodies.com\Prospects\ViewApp.cfm:170)
at cfViewApp2ecfm1509789985.runPage(D:\Websites\goldenmelodies.com\Prospects\ViewApp.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:484)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
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:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:536)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:898)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
|
|