number compare 1

[doorbreaker]

Hi,

I am having trouble comparing 2 numbers:

I have Minspend: 60 and ProductTotal: 339.2

<% if minspend < producttotal then %>

do stuff

<% end if %>

This doesn't do anything. However if I change the ProductTotal to anything above 600 then it does work. So it is only looking at the first 2 numbers of my ProductTotal variable.

How do I stop it doing this and look at the entire number?

Thanks

Chris Moore

 

[Hameedullah]

try casting

<% if cdbl(minspend) < cdbl(producttotal) then %>

do stuff

<% end if %>

Cheers,
Hameed

You are either the slave of what made men or what men made.

 

[DotNetGnat]

CDBL() should do it...

-DNG

 

[doorbreaker]

thanks, this worked a treat