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 "suggest"
a structured format for browser clients. Often people
will use various tricks to force a standard layout.
IMHO, none of the tricks are of such high value that
I would retard the development schedule of a website
until every em and en are exactly delineated.

That being said, there are things to do - subject to
the understanding that you will have no control over whether
a particular client browser is:
1. using a proportional typeface;
2. using a non-proportional typeface;
3. employing a display size that makes hash of http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: [RE: padding a variable] " "

2000-11-03 Thread Mark Johnson

Using this function another way would be.

ReReplace(LJustify(myColumn, 30)," "," ","ALL")

Mark Johnson
---
Senior Cold Fusion Developer
Cardinal Communications

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 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 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 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: [RE: padding a variable]

2000-11-03 Thread Alex

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?


"Chapman, Katrina" <[EMAIL PROTECTED]> wrote:
That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try 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 - 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 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]



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]


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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



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 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



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 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



Re: [RE: padding a variable] " "

2000-11-03 Thread Alex

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 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 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]



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 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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]