elder

 I tried something  and now I get this error:

The value "glwins" cannot be converted to a number
The error occurred in
/home/httpd/vhosts/domain.com/httpdocs/demo22/standings.cfm: line 55

53 : #glwins# - #gllosses#
54 : #skillrating#
55 : #val(calcwins/(calwins+calclosses))#
56 : streak
57 : idle time

How can a field with data type INT with numbers in it not be converted to a
number when it IS a number already?

Thanks.

Code

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
        <title>Standings</title>
</head>

<body>

<!--- Query The Database For All Records In That Table --->
<cfform>
<cfinput type="hidden" name="lgname" value="demo22">

</cfform>

<CFSET calcwins = 'glwins'>
<CFSET calclosses = 'gllosses'>



<CFQUERY NAME="GetRecords" DATASOURCE="glmembers">
   SELECT          lgrank, membername, membershipicon, glwins, gllosses, glwinperc, skill
rating, streak, idletime, nowbux, lifebux, highrank, highskill, highstreak
   FROM             members
   WHERE lgname='demo22'
                              ORDER BY      lgrank, membername

</CFQUERY>



<link rel=StyleSheet href=http://www.domain.com/main.css type=text/css>
<table cellspacing="2" cellpadding="2" border="1" frame="box" rules="all">
<tr bgcolor="#000080">
    <td><font color="#FFFFFF">Rank</font></td>
    <td><font color="#FFFFFF">Member Name</font></td>
    <td><font color="#FFFFFF">&nbsp;</font></td>
    <td><font color="#FFFFFF">Wins - Losses</font></td>
    <td><font color="#FFFFFF">Skill Rating</font></td>
    <td><font color="#FFFFFF">Win %</font></td>
    <td><font color="#FFFFFF">Streak</font></td>
    <td><font color="#FFFFFF">Days Idle</font></td>
    <td><font color="#FFFFFF">Bux Now</font></td>
    <td><font color="#FFFFFF">Bux Life</font></td>
    <td><font color="#FFFFFF">High Rank</font></td>
    <td><font color="#FFFFFF">High Skill</font></td>
    <td><font color="#FFFFFF">High Streak</font></td>
</tr>
<CFOUTPUT QUERY="GetRecords">
<tr>
          <CFOUTPUT QUERY="GetRecords">
<tr>
    <td>#GetRecords.CurrentRow#</td>
    <td><a href="http://www.domain.com/demo22/#membername#">#membername#</a></td>
    <td>#membershipicon#</td>
    <td>#glwins#  -  #gllosses#</td>
    <td>#skillrating#</td>
    <td>#val(calcwins/(calwins+calclosses))#</td>
    <td>streak</td>
    <td> idle time </td>
    <td bgcolor="green"><font color="white">#nowbux#</font></td>
    <td bgcolor="green"><font color="white">#lifebux#</font></td>
    <td>#highrank#</td>
    <td>#highskill#</td>
    <td>#highstreak#</td>
</tr>
</CFOUTPUT>

</table>


</body>
</html>