RE: padding a variable

2001-01-10 Thread Jann VanOver
ry this > > > > #foo# - #len(foo)# > > > > > > > > > > > > #foo# - #len(foo)# > > > Of course you can replace the @ with whatever char you want to use. > > --K > > -Original Message- > From: Philip Arnold

Re: [RE: padding a variable]

2000-11-03 Thread pan
From: "Alex" <[EMAIL PROTECTED]> > i can do this BUT not with spaces [ ] > how can i get a query field that takes up 10 or less characters to take up > exactly 30 characters in the browser? > HTML is not a lay-out tool for page publishing. It is a sub-sub-set of SGML which is designed to "sug

Re: padding a variable

2000-11-03 Thread Tom Muck
#len(foo)# > > > > > > > > > > > > #foo# - #len(foo)# > > > Of course you can replace the @ with whatever char you want to use. > > --K > > -----Original Message- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Se

RE: [RE: padding a variable] " "

2000-11-03 Thread Mark Johnson
vember 03, 2000 5:58 PM To: CF-Talk Subject: Re: [RE: padding a variable] " " spaces get truncated. that is my problem "David Gassner" <[EMAIL PROTECTED]> wrote: The LJustify() function is designed for exactly this purpose: LJustify(myColumn, 30) > -Original Messag

RE: padding a variable

2000-11-03 Thread Mark Johnson
Here is a way to do it with less steps. Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 5:54 PM To: CF-Talk Subject: RE: padding a variable

Re: [RE: padding a variable]

2000-11-03 Thread Alex
ginal Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 5:23 AM To: CF-Talk Subject: RE: padding a variable > how do you pad a variable in CF. > for example how can I force a query.columnname to take up exactly 30 > characters? Just using Le

RE: [RE: padding a variable]

2000-11-03 Thread Simon Horwith
or add x number of #Chr(32)# 's to the value (#chr(32)# is the ASCII value for a space) depends on your needs ~Simon -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 1:06 PM To: CF-Talk Subject: RE: [RE: padding a variable]

RE: padding a variable

2000-11-03 Thread Chris Evans
Or, Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 12:54 PM To: CF-Talk Subject: RE: padding a variable That's not the queston boys. He's not asking how to limi

Re: padding a variable

2000-11-03 Thread Billy Cravens
-- Billy Cravens [EMAIL PROTECTED] Alex wrote: > > how do you pad a variable in CF. > for example how can I force a query.columnname to take up exactly 30 > characters? > > > Get free email and a permanent address at http:

RE: [RE: padding a variable]

2000-11-03 Thread David Gassner
Use a non-breaking space: #myColumn##padding# > -Original Message- > From: Alex [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 03, 2000 8:24 AM > To: CF-Talk > Subject: Re: [RE: padding a variable] > > > how do i get it to show 30 characters without t

RE: [RE: padding a variable]

2000-11-03 Thread Hayes, David
To do that, you'll have to replace the spaces with " " to generate non-breaking spaces for the browser. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 10:24 AM To: CF-Talk Subject: Re: [RE: padding a variable] how do i ge

Re: [RE: padding a variable] " "

2000-11-03 Thread Alex
November 03, 2000 5:23 AM > To: CF-Talk > Subject: RE: padding a variable > > > > how do you pad a variable in CF. > > for example how can I force a query.columnname to take up exactly 30 > > characters? > > Just using Left() won't work if you're us

RE: padding a variable

2000-11-03 Thread Chapman, Katrina
course you can replace the @ with whatever char you want to use. --K -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 5:23 AM To: CF-Talk Subject: RE: padding a variable > how do you pad a variable in CF. > for exam

Re: [RE: padding a variable]

2000-11-03 Thread Alex
how do i get it to show 30 characters without the browser truncating spaces "Philip Arnold - ASP" <[EMAIL PROTECTED]> wrote: > how do you pad a variable in CF. > for example how can I force a query.columnname to take up exactly 30 > characters? Just using Left() won't work if you're using variab

RE: padding a variable

2000-11-03 Thread David Gassner
The LJustify() function is designed for exactly this purpose: LJustify(myColumn, 30) > -Original Message- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 03, 2000 5:23 AM > To: CF-Talk > Subject: RE: padding a variable > > > >

RE: padding a variable

2000-11-03 Thread Philip Arnold - ASP
> how do you pad a variable in CF. > for example how can I force a query.columnname to take up exactly 30 > characters? Just using Left() won't work if you're using variable length fields (varchar) You could use Left(myColumn & RepeatString(" ", 30), 30) HTH Philip Arnold ASP Multimedia Limite

RE: padding a variable

2000-11-02 Thread Peter Alexandrou
Excuse me if I am misunderstanding your question but you could simply limit the field's length in its database definition to varchar(30). Alternatively you could do a Left(query.columnname, 30). > -Original Message- > From: Alex [mailto:[EMAIL PROTECTED]] > Sent: Friday, 3 November 2000