In the query - try concatenating an x with the textnumber field so the results set would contain x0012345,x00123 then in the cfoutput use mid(qdfResult.textnumber, 2, 99999)
I think SQL would look like.. SELECT 'x' & textnumber as NewTextNumber Martin. -----Original Message----- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 22:21 To: CF-Talk Subject: RE: Preserve Leading 0's question in cfoutput. 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186190 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
