You running them through a QofQ, by chance? Or doing any arithmetic with them? Because CF shouldn't strip the zeros unless it's converting them to numbers, and it shouldn't do that unless it actually needs to.
cheers, barneyb On Fri, 3 Dec 2004 16:49:36 -0500, Jeff Waris <[EMAIL PROTECTED]> wrote: > Here's an interesting one... > > I have a text field in a database that contains numbers because of a need to > PRESERVE leading 0's > i.e. > 0001234 > 0123 > 12300 > > Using a regular query, pulling the numbers OUT of the database DROPS the > leading 0's in the cfoutput. Almost like cold fusion is treating it as a > number not a text field. Is there any way to preserve those leading 0's > inside a CFoutput?? > > Thanks.. > > Jeff -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186181 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
