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]
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 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 variable length fields
(varchar)
You could use Left(myColumn & RepeatString(" ", 30), 30)
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
