RE: something different about numbers over 1000?

2004-08-11 Thread Mark W. Breneman
I just had a problem with this... Not sure if you are seeing the same problem I used CF's numberformat to round to two decimal places.All worked find until a 4 digit hit it. Numberformat sticks in ',' in as in 1,000 and then this is a srting and not a number. HTH Mark W. Breneman -Cold

RE: something different about numbers over 1000?

2004-08-11 Thread Mark W. Breneman
Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 _ From: Christy Carter [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 11:27 AM To: CF-Talk Subject: Re: something different about numbers over 1000? Mark, I use NumberFormat as well

Re: something different about numbers over 1000?

2004-08-11 Thread Christy Carter
Hmmm, I tried just putting '' as the mask, but then I can't even download the documents with IDs less than 1000, or the ones greater than 1000 either. I don't need decimal places, just one big long number (integer) with no commas.Any other format I could use, I wonder. I'll have to keep

RE: something different about numbers over 1000?

2004-08-11 Thread Mark W. Breneman
PROTECTED] Sent: Wednesday, August 11, 2004 11:48 AM To: CF-Talk Subject: Re: something different about numbers over 1000? Hmmm, I tried just putting '' as the mask, but then I can't even download the documents with IDs less than 1000, or the ones greater than 1000 either. I don't need decimal places

Re: something different about numbers over 1000?

2004-08-11 Thread Christy Carter
Weird.I put this in:#NumberFormat(url.PropID, '_')# But I can't download any documents then, with IDs or 1000. This is so frustrating. Thanks for your help, Mark - can you see anything I'm doing wrong in the code? Christy :-) [Todays Threads] [This Message] [Subscription] [Fast

RE: something different about numbers over 1000?

2004-08-11 Thread Mark W. Breneman
TECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 _ From: Christy Carter [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 12:18 PM To: CF-Talk Subject: Re: something different about numbers over 1000? Weird.I put this in:#NumberFormat(url.PropID, '_')# But I can't do

Re: something different about numbers over 1000?

2004-08-11 Thread Christy Carter
IT WORKED!!!I used val instead and it works like a charm now. Thanks so much, Mark - you've made my day! :-) Christy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: something different about numbers over 1000?

2004-08-11 Thread Christy Carter
Mark, I use NumberFormat as well, so that's likely my problem too! What did you do instead I'm off to check this out now! Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]