Hey Christy,
Any idea what the error is that cf is throwing?
Are you using cfqueryparams in your query?
I assume that this #NumberFormat(url.PropID, '_')# is in a query like:
Select *
>From table
Where ID = #NumberFormat(url.PropID, '_')#
Try replacing #NumberFormat(url.PropID, '_')# with just val(url.PropID)
Or much better yet go with a
<cfqueryparam value="#url.PropID#" cfsqltype="CF_SQL_INTEGER">
Select *
>From table
Where ID = <cfqueryparam value="#url.PropID#" cfsqltype="CF_SQL_INTEGER">
Mark W. Breneman
-Cold Fusion Developer
-Network 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 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 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 Unsubscribe]
[User Settings]
[Donations and Support]
- something different about numbers over 1000? Christy Carter
- RE: something different about numbers over 1000? Mark W. Breneman
- Re: something different about numbers over 1000? Christy Carter
- RE: something different about numbers over 1000? Mark W. Breneman
- Re: something different about numbers over 1000? Christy Carter
- Re: something different about numbers over 1000? Mark W. Breneman
- Re: something different about numbers over 1000? Christy Carter
- Re: something different about numbers over 1000? Christy Carter
- RE: something different about numbers over 1000? Mark W. Breneman