I tried varchar, nvarchar and char in MS SQL. The DB all shows the 0's. The cfoutput removes the 0's. I even tried the SET like below as well. Still trims the 0's... I'm pulling my hair out...
Jeff > -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 5:10 PM > To: CF-Talk > Subject: Re: Preserve Leading 0's question in cfoutput. > > > maybe. Did you try this: > > <cfset textnum = "" & myquery.textnumber /> > > > On Fri, 3 Dec 2004 16:58:42 -0500, Jeff Waris > <[EMAIL PROTECTED]> wrote: > > 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 > > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/blog/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186186 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
