RE: Strange issue with large numbers

2004-06-15 Thread Raymond Camden
CF does have a concept of a maxint, the largest number it can hold correctly. Unfortunately when you run into this, you never get an exception, you just get wierd behaviour. For example, dateDiff, when returning a result that is too big, will simply roll over. I'm not quite sure what the best way

Re: Strange issue with large numbers

2004-06-15 Thread Ian Sheridan
Well we ended up using CONTAINS and DOES NOT CONTAIN and it seems work consistently. Well I think that this is an issue that should at lease, as you say, throw and exception. On Jun 15, 2004, at 1:03 PM, Raymond Camden wrote: CF does have a concept of a maxint, the largest number it can hold