Railo 4.0.4.001 Error (database)
Message Conversion failed when converting the nvarchar value '52.1398' to data type int.
SQL
SELECT DISTINCT
DVPNTN_CUSTOMERS.company_name,
DVPNTN_CUSTOMERS.address1,
DVPNTN_CUSTOMERS.postal,
DVPNTN_CUSTOMERS.city,
DVPNTN_CUSTOMERS.phone,
DVPNTN_CUSTOMERS.fax_no,
DVPNTN_COUNTRY.Country_name,
DVPNTN_CUSTOMERS.email,
DVPNTN_CUSTOMERS.HOME_PAGE,
depLat,
depLon
FROM HOSTETCLV101_04.IXSNTN55.dbo.DVPNTN_CUSTOMERS
INNER JOIN HOSTETCLV101_04.IXSNTN55.dbo.DVPNTN_COUNTRY ON country = code
INNER JOIN tDealer ON depUsersId = DVPNTN_CUSTOMERS.nav_customer_number

INNER JOIN tZip ON (6371 * acos(Round(cos(radians(zipLatitude)) * cos(radians(depLat))
* cos(radians(depLon) - radians(zipLongitude)) + sin(radians(zipLatitude))
* sin(radians(depLat)), 10))) < 100

WHERE BLOCKONDEALERLIST = 0
AND depActiveYN <> 0
AND code = 'DE'
AND depLat <> 0
AND depLon <> 0




AND zipName = 'Müllheim'




DatabaseName Microsoft SQL Server
DatabaseVersion 10.50.4339
DriverName Microsoft SQL Server JDBC Driver 3.0
DriverVersion 3.0.1301.101
Datasource ixs_de_cms
Stacktrace The Error Occurred in
C:\web-data\motochic.de\http\pages\dyn\map\index.cfm: line 138
136: <cfif txtHaendler NEQ "">
137: AND DVPNTN_CUSTOMERS.company_name LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#txtHaendler#%">
138: </cfif>
139: </cfquery>
140:

called fromC:\web-data\motochic.de\http\GetInside.cfm: line 48
called fromC:\web-data\motochic.de\http\index.cfm: line 313
Java Stacktrace Conversion failed when converting the nvarchar value '52.1398' to data type int.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4762):4762
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1682):1682
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955):955
   at railo.runtime.type.QueryImpl.fillResult(QueryImpl.java:422):422
   at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:238):238
   at railo.runtime.tag.Query.executeDatasoure(Query.java:627):627
   at railo.runtime.tag.Query.doEndTag(Query.java:475):475
   at pages.dyn.map.index_cfm$cf.call(C:\web-data\motochic.de\http\pages\dyn\map\index.cfm:138):138
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:749):749
   at getinside_cfm$cf.call(C:\web-data\motochic.de\http\GetInside.cfm:48):48
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:749):749
   at index_cfm$cf.call(C:\web-data\motochic.de\http\index.cfm:313):313
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:754):754
   at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:36):36
   at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2255):2255
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2222):2222
   at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:315):315
   at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407
   at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1
   at java.lang.Thread.run(Unknown Source):-1