Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Www.xxxcon., %s wwwxxxcon, %s wwwxxxcon, www.xxxcon, xxxxdup, bitlord outgoing port settings, ckowwwxxx, 192.168.1.41:8000/nor-482.html, php.ini "Unable to initialize module", sendmail add footer to all messages

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