Mark Henderson wrote:
>Moving on from where I left off the other day, I would now like to be able to round the following output to zero decimal places.
>
>Here's my query
>=====================================
><cfquery name = "results" datasource = "#request.dsn#">
> SELECT *
> FROM results
> WHERE team_name IS NOT NULL
> ORDER BY total_score DESC
></cfquery>
>
>
>And the resulting output.
>=====================================
> <cfoutput query="results">
> <tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('eeeeee'))#">
> <td>#team_name#</td>
> <td>#results["wins_round_#round_number_results#"][currentRow]#)</td>
> <td>#results["margin_round_#round_number_results#"][currentRow]#</td>
> <td>#total_wins#</td>
> <td>#total_margins#</td>
> <td>#total_score#</td>
> </tr>
> </cfoutput>
>
>
>All resulting output apart from the team_name is in number format (that's how it's set up in the database, and I know I could just change it to text and this would fix my problem, however I don't think it's an ideal solution).
>
>So I'd like to round columns 2 and 3 to zero decimal places. I've investigated the round property without much luck.
>
>I'm sure this isn't too complicated....Any ideas?
>
>TIA
>Regards
>Mark Henderson
>Web Designer
>mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
