You forgot a round in there too. ;)
On Mon, May 2, 2011 at 9:10 PM, Justin Scott <leviat...@darktech.org> wrote: > of course). If I have a numeric ID, I'm going to > min(abs(val(trim(url.id))), 2000000) that variable before it ever > makes it to the query (forces a positive in-range integer or zero; the > two billion value can be modified if you're using larger numbers in > your situation; an error can occur if the integer value is out of > range so I force it in range as well). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm