19.0 instead of 19

[aarontra]

In the loop below

<CFLOOP QUERY=myquery>
<A HREF=&quot;mypage.cfm?myvar=#myvar#&qvar=#myquery.ID#&quot;>edit occurence</A>

</cfloop>

the variable myvar is not part of the query.

CF makes the value of 19 into 19.0
?myvar=19.0&qvar=2

Other links on the page use
?myvar=#myvar# without evaluating #myvar# to 19.0

How do I make it stay without the <myvar>.0 on the end of it?

because it later breaks this page when I return the user back to the form.
If I change the querystring to ?myvar=19 it is fine again.

Thank you
Aaron

 

[aarontra]

Ok I sort of fixed it with
<cfset myvar = Replace(myvar,&quot;.0&quot;, &quot;&quot>
still would like to know how to not have it but the value with .0 on the end in the first place.

I am using MS Access which could be important.

Aaron

 

[Krogh]

there is the NumberFormat function to fix it...
NumberFormat(number,mask)

just use it that way
#NumberFormat(myvar,&quot;99999&quot#
this will not display the decimal part of any number

 

[aarontra]

Thank you

although

myvar = int(myvar)
seems to work better for my app. (I was looking for a number in a list of numbers.)

since #NumberFormat(myvar,&quot;99999&quot#
pads the number with spaces