Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

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