Re: Reveral of a field

2001-04-12 Thread Mark Woods

trim(listLast(field)) & " " & trim(listFirst(field))

At 12:47 PM 4/12/2001, you wrote:
>Hi,
>I have a field with Smith, John as the contents.
>
>I want to display John Smith...
>
>I'm think I get the total length(a), then the charlength of the comma(b).
>
>Take contents b + 1 and subtract that from a equals (c)
>Then display the difference of c to a (d)
>and then output c after d to the total of the field
>
>Any other ideas?
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Reveral of a field

2001-04-12 Thread Brian bouldernet

Cool. Thanks.
- Original Message -
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 4:55 AM
Subject: RE: Reveral of a field


> you could use the listfirst and listlast functions.  assuming that your
> names are alwas Last, First:
>
> 
>
> 
> #listlast(thename)# #listfirst(thename)#
> 
>
> make sense?
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 7:48 AM
> To: CF-Talk
> Subject: Reveral of a field
>
>
> Hi,
> I have a field with Smith, John as the contents.
>
> I want to display John Smith...
>
> I'm think I get the total length(a), then the charlength of the comma(b).
>
> Take contents b + 1 and subtract that from a equals (c)
> Then display the difference of c to a (d)
> and then output c after d to the total of the field
>
> Any other ideas?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Reveral of a field

2001-04-12 Thread Christopher Olive, CIO

you could use the listfirst and listlast functions.  assuming that your
names are alwas Last, First:




#listlast(thename)# #listfirst(thename)#


make sense?

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 7:48 AM
To: CF-Talk
Subject: Reveral of a field


Hi,
I have a field with Smith, John as the contents.

I want to display John Smith...

I'm think I get the total length(a), then the charlength of the comma(b).

Take contents b + 1 and subtract that from a equals (c)
Then display the difference of c to a (d)
and then output c after d to the total of the field

Any other ideas?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists