Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Formatting Data Results...proper case

Posted on 2008-04-09 18:33:47 by CD

I have a asp page pulling results from an Access DB. I have no control of
the data input to the db. All the information is entered in Upper case. It
contains fields like address, city, etc..

DB data:
AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue

Is there a way to format the data on the webpage in proper case with a
fucntion or routine? I am not a programmer by trade but can follow logic.

TIA
CD

Report this message

#2: Re: Formatting Data Results...proper case

Posted on 2008-04-09 22:07:21 by Paxtonend

"CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
news:ePmWA%23lmIHA.4076@TK2MSFTNGP05.phx.gbl...
>I have a asp page pulling results from an Access DB. I have no control of
>the data input to the db. All the information is entered in Upper case.
>It contains fields like address, city, etc..
>
> DB data:
> AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue
>
> Is there a way to format the data on the webpage in proper case with a
> fucntion or routine? I am not a programmer by trade but can follow logic.
>
> TIA
> CD
>

http://classicasp.aspfaq.com/general/how-do-i-convert-a-name -to-proper-case.html

--
Mike Brind
Microsoft MVP - ASP/ASP.NET

Report this message

#3: Re: Formatting Data Results...proper case

Posted on 2008-04-15 13:29:09 by CD

THANKS....excalty what I needed.


"Mike Brind [MVP]" <paxtonend@hotmail.com> wrote in message
news:uIMIS1nmIHA.4292@TK2MSFTNGP04.phx.gbl...
>
> "CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
> news:ePmWA%23lmIHA.4076@TK2MSFTNGP05.phx.gbl...
>>I have a asp page pulling results from an Access DB. I have no control of
>>the data input to the db. All the information is entered in Upper case.
>>It contains fields like address, city, etc..
>>
>> DB data:
>> AddressColumn: 123 BILL AVENUE format to 123 Bill Avenue
>>
>> Is there a way to format the data on the webpage in proper case with a
>> fucntion or routine? I am not a programmer by trade but can follow
>> logic.
>>
>> TIA
>> CD
>>
>
> http://classicasp.aspfaq.com/general/how-do-i-convert-a-name -to-proper-case.html
>
> --
> Mike Brind
> Microsoft MVP - ASP/ASP.NET
>

Report this message

#4: Re: Formatting Data Results...proper case

Posted on 2008-04-15 14:25:10 by McKirahan

"CD" <mcdye1@hotmail.REMOVETHIS.com> wrote in message
news:eK#UuvunIHA.5368@TK2MSFTNGP04.phx.gbl...
> THANKS....excalty what I needed.

> >
http://classicasp.aspfaq.com/general/how-do-i-convert-a-name -to-proper-case.
html

"there is no universal way ... to handle proper casing correctly, 100% of
the time."

For example, DuPont, O'Leary, von Furstenburg, et.al.

Report this message