Would a cfset giving the variable a more friendly name be considered arithmatic and trim the 0's?
i.e. <cfset textnum = myquery.textnumber> Jeff > -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 4:54 PM > To: CF-Talk > Subject: Re: Preserve Leading 0's question in cfoutput. > > > 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 Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186182 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
