Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered.
|
|
The error occurred in D:/home/vhsl-reference.com/wwwroot/mostimproved.cfm: line 140
|
138 : <cfif NOT IsDefined("url.per")>
139 : l.finalrating - e.finalrating DESC
140 : <cfelse>
141 : 100* ((l.finalrating-e.finalrating)/(e.finalrating)) DESC
142 : </cfif>
|
|
SQLSTATE |
22012 |
DATASOURCE |
vhsl2_MSSQL |
VENDORERRORCODE |
8134 |
SQL |
SELECT l.TEAMID, l.TEAMNAME, l.GY AS LaterGY, l.finalrating AS LaterFinalRating, e.finalrating AS EarlyFinalRating, e.GY AS EarlyGY,
100* ((l.finalrating-e.finalrating)/(e.finalrating)) AS NetDiff
FROM TEAMSEASONRATINGINFO AS e INNER JOIN TEAMSEASONRATINGINFO AS l ON l.teamID = e.TeamID AND l.GY = e.GY+1 WHERE l.GY =2007
ORDER BY
100* ((l.finalrating-e.finalrating)/(e.finalrating)) DESC
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
54.157.56.179 |
Referrer |
|
Date/Time |
29-Mar-24 08:16 AM |
|